Use one header row.
One name per row.
Put each field into a different column.
different columns for
Honorific (mr., mrs. ms. the reverend, etc)
First Name
middle Initial
Last Name
First Address
2nd address
city
st
zip (zip+4)
phone number (enter as numeric and format it as special|Phone)
And any other field you can think of should be a separate column. It's really
easy to combine two fields into one (=a1&" "&b1), but it's much more difficult
to separate them.
Different fields for each kid's name, spouse's name, ages, birthdates, notes.
(You can always move columns to the right or left (and even insert more) later.
And after you do that you'll be ready to use Word's mailmerge to create
envelopes/letters.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.