 Click here to download a Mailing Data Template in Excel format.
Click here to send your file to Handy Mailing Services.
Do's & Don'ts when creating a Mailing List.
1. Required field headings below. You may require additional fields.
Prefix |
First Name |
Middle Name |
Last Name |
Suffix |
Company |
Mr. |
John |
Edward |
Smith |
Jr. |
City Print |
Dr. |
John |
Edward |
Smith |
|
|
Mail Add |
Alt Add |
City |
State |
Zip |
Provence |
Inter Zip |
Country |
29 W St |
PO Box 5 |
May |
CA |
91723 |
|
|
|
3 E. St |
PO Box 6 |
West |
Smith |
|
Ontario |
ZBC 123 |
Canada |
2. Do not spell out states. Use correct abbreviations.
3. Use only proper abbreviations. (Co does not equal County, CR does not equal Circle).
4. There is a difference between State Hwy, US Hwy, County Rd and County Rt.
5. Do not use punctuation.
6. Do not put other information in these fields.
7. If using Full Name field instead of separate fields, always put First Name First, Last Name Last.
8. Keep City State and Zip in separate fields.
9. Use the following web address to standardize and verify address www.usps.com
10. When gathering information thru a web site, use drop down boxes for States and Countries in order to get proper abbreviations and names.
11. If your addresses are in a file such as Word or Notepad, export into a delimited file. Examples: ASCII comma or tab delimited.
|
