What's the best way to convert a contact list to mailing labels?

W

Wombatmanforever

I need to compile a long contact list that includes information on name of
organization, name of contact person, address, location of contact person,
phone #s, e-mail, etc. I am thinking Excel would be the best tool to organize
all this info, but is there an efficient way to set it up so that mailing
labels can be made from the information?

I'm afraid I don't know what version of the Office software I will be using.
This is advance planning.

Thank you!
 
H

Herb Tyson [MVP]

Excel is fine for managing the data source--a Word table is good too, as is
Access. But, Excel probably gives you the best combination of control and
flexibility.

Put the field names (Name, address, city, etc.) in the top row. In Word, use
mailmerge, and tell it to use an existing source, and point it at the Excel
file. The column headings (top row) will show up in Word as merge fields.

This article should help with the details:

http://word.mvps.org/faqs/MailMerge/CreateAMailMerge.htm
 
J

Jay Freedman

I need to compile a long contact list that includes information on name of
organization, name of contact person, address, location of contact person,
phone #s, e-mail, etc. I am thinking Excel would be the best tool to organize
all this info, but is there an efficient way to set it up so that mailing
labels can be made from the information?

I'm afraid I don't know what version of the Office software I will be using.
This is advance planning.

Thank you!
Click to expand...

See http://www.gmayor.com/convert_labels_into_mail_merge.htm.
 
Top