Mailing Label wizard

[Guest]

In Word 2003 I can no longer make mailing labels from a database in Excel.
It wants me to be a company instead of a small club that mails monthly
newsletters. It thinks all my data is in Outlook instead of Excel also. How
can I custom make a basic mailing label based on my headers in Excel? I could
do this easily when I had Word 2000.

 

[Suzanne S. Barnhill]

I use Excel data sources for mail merges all the time in Word 2003. You can
absolutely select an Excel sheet as a data source. Where are you
encountering difficulty?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

I encounter problems when I go to Word and try to find a way to go through
the mailing label wizard. In Office 2000 this was easy. Can you give me the
path as help doesn't do it for me. It tries to do a mailing letter type of
label instead of one created from my Excel list. To format the label with my
Excel headers is what I used to do in 2000. Thanks for any help.

 

[Suzanne S. Barnhill]

FWIW, I never use the wizard, but it should give you the opportunity at the
outset to choose the type of merge (Labels) and the data source (you have to
browse for it). If you're fairly familiar with how to create mail merges,
you can do it manually using the Mail Merge toolbar, which has a button for
Open Data Source. You might find these articles helpful:

Mail merge labels with Word XP
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Express mail merges in Word 2002 and 2003
http://sbarnhill.mvps.org/WordFAQs/ExpressMailMerges.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Thank you Suzanne, I will go over your tutorials and see if I can solve the
problem. Your information is very interesting. Thanks again.

Lynne