PH No (321) 729-6245
Toll Free (800) 940-5478
FAX (321) 242-1382		  250 N. Babcock Street
 Melbourne, FL 32935
 Email chuck@addressnmail.com

       Address N' Mail Standard Database Formats

 Standard Residential Database Format
 Standard Business Database Format
 Custom Database
 Examples of various databases types/views
 Acceptable Database Extensions

Return to previous page

Standard Residential Database Format

Format A

Format B

Field Name

Maximum Allowed
Characters

Field Name

Maximum Allowed
Characters

Full Name

34

Full Name

34

Address

34

Address1

34

City

20

Address2

34

State

2

City

20

Zip Code

10

State

2
   

Zip Code

10

Return To Top

Standard Business Database Format

Format C

Format D

Field Name

Maximum Allowed
Characters

Field Name

Maximum Allowed
Characters

Full Name

34

Full Name

34

Company

34

Company

34

Address

34

Address1

34

City

20

Address2

34

State

2

City

20

Zip Code

10

State

2
   

Zip Code

10

Notes:

  1. On Standard Database Format B or C, only use a PO Box or Street Number in an address field. Do Not include both.
  2. In the Zip Code field, include the leading zeros in the first 5 digit of the Zip Code if there are less 5 digits (ie 00245).
  3. For a 5+4 Zip Code use the following format: 32903-1134, 00234-1245
  4. If you want all the address fields from your database to appear with mixed upper and lower case characters on the mailing labels, you will have to communicate that information to Address N’ Mail. Our standard format is to use all upper case characters for the mailing labels.
  5. Make sure that the database you send us has the First Name first in the Full Name Field.
  6. If there is a suite number for Format A and C, make sure you include it in the address field.
  7. For Format B and D make sure you include the suite number and/or mail stop in one of the address fields.
  8. If you wish to include the title of the individual, include that in the Full Name field.
  9. To prevent additional database service charges, please make sure we receive you information in one of the above formats.

Return To Top

Custom Database

Customer’s Database (Example)

  

Address N’ Mail

Field Position


Field Name

Maximum
Number
of Characters

  

Field Name

Maximum
Allowed
Characters

1

Last Name

20

  

First Name

34

2

First Name

20

  

Last Name

34

3

Company

34

  

Title

34

4

Title

34

  

Company Name

34

5

Addr 1

34

  

Address1

34

6

Addr 2

34

  

Address2

34
       

Address3

34

7

City

20

  

City

20

8

ST

2

  

State

2

9

Zip

10

  

Zip Code

10

10

Phone No

15

  

Option A

34

11

Fax No

15

  

Option B

34

12

Age

2

  

Option C

34

13

Renter (Y/N)

1

  

Option D

34

14

Apt No

34

  

Option E

34

15

Home Owner (N/Y)

1

  

Option F

34
       

Option F

34
       

Option F

34
       

Option F

34
       

Option F

34

Notes:

  1. Middle Initials should be included in the First Name Field.
  2. Unless otherwise stated, Address N’ Mail will use one of the Standard Formats to
    generate mailing labels.
  3. Optional fields sometimes include telephone numbers, age, wealth, homeowner, etc.
  4. Usually the apartment number is entered in address3 field.
  5. Please contact Address N’ Mail for other database questions and for the database
    conversion charges.

Return To Top

The below are examples of various databases types/views:

Microsoft Excel spreadsheet, Access, dBase IV, etc.

Full Name

Address

City

ST

Zip Code

John Doe

2405 Melbourne Ave

Melbourne

FL

32901

Mary A Lewis

2010 N Highway A1A Apt 15

Indialantic

FL

32903-2356

Hank Williams

130 Madison Ave Apt 100

New York

NY

03561

Valerie Jones

3421 Hilton St

Boston

MA

00245-1432

 

Quote and Comma Delimited format.
This sometimes referred to as simply comma delimited data

"Full Name"," Address", "City", "ST"," Zip Code"
"John Doe","2405 Melbourne Ave","Melbourne","FL","32901"
"Mary A Lewis","2010 N Highway A1A Apt 15","Indialantic","FL","32903-2356"
"Hank Williams","130 Madison Ave Apt 100","New York","NY","03561"
"Valerie Jones","3421 Hilton St","Boston","MA","00245-1432"

Note:

  1. The quotation surrounding each field assures that an imbedded comma does not act as a field delimiter.
  2. When using Microsoft Excel spreadsheets, format the Zip Code column using the following directions. From the Menu Bar click on Format, then click on the Cells from the Menu list, next click on the Numbers Tab, and finally click on Zip Code not Zip Code + 4.
  3. When submitting your database in Comma Delimited format, please specify the field names in the header and the maximum number of characters in each field.

Return To Top