An Address Mess!

[Carolina78703]

Hello, Excel experts.

I have a spreadsheet of address and other contact info for about 15
people. I would like to convert it into a printable directory in
non-spreadsheet format*, so I may print and distribute hard copies o
it.

I would like to do this not in Outlook, but either in Excel where th
data currently is, or in Word-- so that in either case I can customiz
the format to my liking easier. (or I think ... I hope!? )

Thank you much in advance!
Carol

*A sample entry might be in this format:

A

Arnold, Kimberly
111 Main St.
Somewhere, NY 11111
email- (e-mail address removed)
phone- 111-111-1111
birthdate- 11-11-1111
Husband: Bra

 

[Debra Dalgleish]

You can use the Mail Merge feature in Word to print the data, with your
Excel file as the data source. There's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

And David McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm