Home Table of Contents Feedback Search

   

  

  

  

  

  

 

 

 

 

 

 

 

DATABASE GUIDELINES

 

The most often used applications for maintaining a database include Microsoft Excel and Microsoft Access which can be imported into our software. We also can convert delimited text files, whether it be delimited by a comma, space, or a unique character. Some other formats include DBase, Microsoft Word label formats, or Microsoft Works spreadsheet files.

 

It is important to make sure your database file adheres to the basic standards of formatting. The following are examples of formatting styles that can be used in our postal software to easily and accurately process your customer/client information. Our postal software will reformat your address information to meet the USPS mailing specifications to improve delivery and lower postage rates. The examples show addresses missing some information such as zip codes or misspelled words to show the effectiveness of our software, but it is recommended that you offer as much correct information as possible within your databases to improve the address correction process.

 

Example 1

Spreadsheet Style - Expanded fields (recommended format)

 Your database file:
 PREFIX  FIRST  LAST  ADDRESS1  ADDRESS2  CITY  STATE  ZIP
 Mr.  Mike  Smith  44 May Road  Apartment 7  Metro  Indiana  47000
   SALLY  MALL  1 FIELD AVENUE      KY  41042
 fixes upper/lower case fields, combines address1 and address2 fields, updates city, state, and zip codes
 Our software:
 PREFIX  FIRST  LAST  ADDRESS1  ADDRESS2  CITY  STATE  ZIP
 Mr.  Mike  Smith  44 May Rd Apt 7    Metro  IN  47000-1432
   Sally  Mall  1 Field Ave    Florence  KY  41042-4356

 

Example 2

Spreadsheet Style - Condensed fields

 Your database file:
 FULLNAME  ADDRESS  CITYSTATEZIP
 mr. John a. Doe  123 Dwntwn Street  ANYWHERE Ohio 45
 Jane DOUGH  5 Third Street Floor 2  Flo, KY, 41042
 fixes upper/lower case fields, splits the fullname fields, corrects address line, provides complete zip codes.
 Our software:
 PREFIX  FIRST  MIDDLE  LAST SUFFIX  ADDRESS  CITY  STATE  ZIP
 Mr.  John  A.  Doe    123 Downtown St Anywhere OH 45209-1205
   Jane    Dough    5 3rd St Fl 2 Florence KY 41042-9541

 

 

Examples of other  accepted formats.

 

Comma delimited text files (fields separated by a comma)

 

    First, Last, Company, Address, City, State, Zip

    John, Doe, Marketing Inc., 321 Market Street, Cincinnati, OH, 45011

 

 

Fixed length text files (fields have a set length)

 

First

Last

Company

Address

City

State

Zip

John

Doe

Marketing Inc.

321 Market Street

Cincinnati

OH

45011

 

 

Label format

 

 Name

 Company

 Address1

 Address2

 CityStateZip

 

 John Doe

 

 321 Market Street

 Apt 6

 Cincinnati OH 45011

 

 Jane Doe

 

 321 Market Street

 

 Cincinnati OH 45011

 

 

Mike Smith

 Borrowers LLP

 321 Market Street

 Floor 2

 Anyplace IN 47022

 

Sally Mall

 Mall Housing Inc.

 1 Field Ave

 

 Florence KY 41042

 

Dr. Berry

 Dental Corp.

 26 Teeth St

 Lower Level

 Cincinnati OH 45011

 

 

 

 

 

DataMark Mailing Services, Inc.

6700 Dixie Hwy LL  Florence, KY 41042

Phone: 859-283-9333 Fax: 859-283-9663 Web: DataMarkMailing.com

Copyright © 2011 DataMark Mailing Services
Last modified: 11/12/11