Share via

Printing assorted address labels, using Avery 5161

Anonymous
2016-09-10T16:26:51+00:00

I have a list of 140 mailing addresses, I am using Avery 5161 Easy Peel East Stick address labels. How do I get Microsoft 7 to print all of these different mailing addresses on the Avery 5161 label paper?

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Jay Freedman 207.6K Reputation points Volunteer Moderator
    2016-09-11T20:03:33+00:00

    If the names and addresses are stored in a proper format (a word table with a separate column for each part of the names and addresses; or an Excel worksheet similarly laid out; or a database table), then use the mail merge feature as described at http://www.gmayor.com/merge_labels_with_word_2007.htm.

    If the names and addresses are just typed line-by-line in a document, first you'll have to rearrange them into a proper format as described at http://www.gmayor.com/convert_labels_into_mail_merge.htm.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-11T18:43:16+00:00

    Hall,

    I am going to change the subject of your post to Word.  Perhaps someone there can walk you through creating the mail merge.  If you could post back with further details (do you have Word, what format is the mailing address in?) someone can be of more assistance.

    0 comments
  2. John Project 49,705 Reputation points Volunteer Moderator
    2016-09-11T15:15:03+00:00

    Hall,

    Sorry but you have posted to a section of this Office forum that deals exclusively with questions/issues about Microsoft Project, a project management application. The misplaced post may be the result of forum re-structuring that took place yesterday so some confusion is understandable.

    You don't mention what application (e.g. Word, Excel, etc.) you used to create your list, but I suggest you re-post to a part of the forum that deals with that application. Filter on the Office Topic for the appropriate application.

    John

    0 comments