Database Design Guidelines for Direct Mail Marketing
This is a suggested minimum structure for designing a new database. By separating a recipient’s information into at least this many fields, the information will be manageable and flexible enough for most direct marketing uses.
- Salutation (Mr/Mrs/Dr)
- First Name
- Last Name
- Suffix (Jr/Sr/III)
- Job Title
- Department
- Company
- Address Line 1
- Address Line 2
- City
- Province
- Postal Code
- Country
- Phone Number
Example:
Mr. John H. Doe
President
XYZ Company
1234 Main St.
Suite 5
Langley, BC V1A 1A!
Canada
(604) 555-1234
