|
Compu-Mail recommends setting up a database using either
- a database management program, like Lotus, Access or DBaseIV
- or spreadsheet program, such as Excel.
Please DO NOT
o use a word processing program
o use more than one line of data in a “cell”
o use punctuation or extraneous characters
City, State, and Zip should be in SEPARATE fields
Keep it as simple as possible,
All lists are confidential and are never sold, rented or in any way distributed
(unless our clients like to SHARE lists.. Compu-Mail is a proponent in “sharing lists.”)
Please call 617.244.6245 for more information.
and for advance persons..
| Field Name |
Length |
Example |
| |
|
|
| FIRST NAME |
25 |
John F. |
| LAST NAME |
25 |
Smith Jr. |
| COMPANY (or second addressee) |
50 |
Mary Jones or IBM Inc |
| MAILING ADDRESS |
50 |
PO Box 1234 |
| DELIVERY ADDRESS |
50 |
123 S Main St #5 |
| CITY |
18 |
Boston |
| STATE |
2 |
MA |
| ZIP |
5 |
02116 |
First Name (include middle name or middle initial)
|
Last Name (include suffix- Sr, Jr, etc)
|
| Company or Second Addressee |
| |
(second addressee could be the second person in a household)
For example: If John F Smith, Jr and Mary Jones lived together
To send them one mailer, the data should be input:
First Name: John F Last Name: Smith Jr
Second Addressee: Mary Jones
|
| Complete Mailing Address |
| |
Post Office Box - printed PO Box
or
Mailing address should only include: number, complete primary street name, street suffix [St, Rd, Ave, etc] Direction [E, W, N, S, etc] and apartment, suite or room number.
Address should not include:
mailstops, company names, building names, Both PO Box and Address, extraneous punctuation or abbreviated street name.
| Wrong: |
Prudential Tower 18th Floor |
| Correct: |
800 Boylston St FL18
|
| Wrong: |
77 Comm Ave-Apt 213 |
| Correct: |
77 Commonwealth Ave Apt 213
|
|
| Delivery Address |
| |
If mailing address is Post Office Box
[UPS, Fedex , Airborne do not deliver to post office boxes]
|
| City |
Correct Postal city name Example: New York City not NYC
|
| State |
Correct 2 letter postal abbreviation Example:
Connecticut=CT not Conn
|
| Zip Code |
A zipcode is not a number, it is text or a zipcode character. Format cell in Excel as 'Zipcode'. If set as a number the leading zero will be dropped
|
Please make note that City, State, and Zip should be in SEPARATE fields
|
