Mailing Label from Excel

[Byron720]

I need to create mailing labels for customers (Avery 5026) that I have in a
Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?

 

[JoAnn Paules]

Use Mail Merge

 

[Byron720]

While it seems to be the logic thing to do, happens that I don't know how to
work with it

Use Mail Merge

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to create mailing labels for customers (Avery 5026) that I have in a
Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?

 

[JoAnn Paules]

Well, that's where the Help file comes in handy. Or even Google if the Help
file isn't being helpful.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

While it seems to be the logic thing to do, happens that I don't know how
to
work with it

Use Mail Merge

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to create mailing labels for customers (Avery 5026) that I have
in a
Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?

 

[Suzanne S. Barnhill]

Absent any information on what version of Word you have, I'd suggest you
look at http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm. If you
have Word 2002 or above, the Mail Merge Wizard will take you through the
process, though some find the Wizard less helpful than the Mail Merge
Helper.

 

[Guy Lydig]

Which version of Word are you using? The answer varies depending on that.

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

you may find http://www.gmayor.com/convert_labels_into_mail_merge.htm
useful

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

While it seems to be the logic thing to do, happens that I don't know
how to work with it

Use Mail Merge

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to create mailing labels for customers (Avery 5026) that I
have in a Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?

 

[Faye]

Use Mail Merge

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to create mailing labels for customers (Avery 5026) that I have in a
Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?

 

[Faye]

While it seems to be the logic thing to do, happens that I don't know how to
work with it

Use Mail Merge

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to create mailing labels for customers (Avery 5026) that I have in a
Excel database. The report looks like this:

Name
Address Line 1
Address Line 2
City, State, Zip Code

How do I transfer the information to Word to create the labels?