Excel Database

  • Thread starter Thread starter Stephen
  • Start date Start date
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.

And a couple of links that may help later:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.
 
Back
Top