convert a list of addresses to 5160 labels?

  • Thread starter Thread starter Guest
  • Start date Start date
jledbetter said:
how do I convert a long list of addresses to 5160 labels?

The best way would be to convert the list into a table, with columns for
Name, Street, City, etc., then do a mail-merge onto labels. How to do the
conversion depends on the current format of the list.
 
Using a mail merge. See these articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

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

How to convert addresses into a Mail Merge Data Source
http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.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.
 
how do I convert a long list of addresses to 5160 labels?

First get the list of addresses into a table or an Excel spreadsheet
in the proper form to be a mail merge source document. These articles
will explain what's needed:
http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm
http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm
http://www.gmayor.com/convert_labels_into_mail_merge.htm

Then do the mail merge, choosing the 5160 label as the destination:
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top