#1
|
|||
|
|||
Another issue I've been running into with Excel for my job is with regard to the best way to have printable address labels from a set of information. The upside is obviously that you can update the data and it will update the label.
However, my efforts with mail merge haven't yielded any success. Avery labels, the brand we use, has templates for Word and other programs, but not Excel. I tried copying the margins from the Word document, and measured out the size of the labels along with the gap between them, but no matter what I have done, I can't get them to print properly on the labels (specifically, 5160 labels from Avery, 30 address labels) Should I continue to pursue a mail merge or should I continue to pursue the creation of a template? I've attached the document I'm using. "Label Full (2)" is the current "printable label" page. |
#2
|
||||
|
||||
For a mailmerge, you'd use Word's own label tools, which include your Avery 5160 format.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
Right. But it wasn't working properly. I'm sure I was doing it wrong, but I'm not sure how to show that here. |
#4
|
||||
|
||||
Telling us only that "it wasn't working properly" is hardly conducive to resolving the issue. If you care to provide some details, we can probably help with that.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Mail Merge Label Template | dazwm | Mail Merge | 20 | 11-21-2017 04:42 AM |
Mail Merge template for all users | cofee | Mail Merge | 1 | 09-08-2016 03:56 AM |
Word Mail Merge Template | newbie406 | Mail Merge | 2 | 02-20-2015 08:08 AM |
Creating new documents from a mail merge template | pnjcarter | Mail Merge | 1 | 02-03-2014 06:42 PM |
Mail merge into a template | born | Mail Merge | 1 | 09-13-2011 01:42 AM |