directory with name/address/phone/birthday
 

I am wanting to know how to go about setting up a format to use for a church
directory. Information in a format similar to below

Name phone #
address
address

Anniversary:
Birthday:

I think you'll have better luck if you put each entry on its own row.

In fact, break up each field into its own column.

Going across the worksheet in row 1 (for headers):
Salutation
FirstName
MI
LastName
Addrees1
address2
city
st
zip
Birthday
anniversary
....

By putting the data in separate columns, it'll make it easy to combine:

=a2&" "&d2

Could return:
Ms. Smith

Then you could apply Data|Filter|autofilter to show/hide the data you want.

And if you ever decide to do a mass mailing (or print labels), you can use this
as your database and MSWord as the template.

You may want to read some tips for mailmerge.
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.


Suzanne wrote:

I am wanting to know how to go about setting up a format to use for a church
directory. Information in a format similar to below

Name phone #
address
address

Anniversary:
Birthday:

--

Dave Peterson