where do i store label info in a contacts database for mailings

Question

I am trying to setup a contacts database for mailings and I am trying to fully automate the labels but can't figure out how.

Where in the database would I store the name that would appear on the top of a mailing label:

• mr & mrs joe thomson
• dr. and mrs james berry
• Schwartz family

This seems like it would have to be a calculated field based on a number of different pieces of data.

Any suggestions on how you have a mailings database and generate names for labels directly?

Answer 1

Building off the data model I suggested in your previous question (which btw is not marked as answered), I'll update the CONTACTS table to include:

• SALUTATION (Mr, Mrs, Dr, etc)

I would determine to use "Thompson Family" versus Mr. Joe Thompson and Mrs. Terry Thompson and Joe and Billy based on the number of personal contacts = 2+ for the same address, with the same last name.

References:

• salutation