View Single Post
 
Old 07-26-2018, 10:57 AM
ShankedS ShankedS is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

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.
Attached Files
File Type: xlsx mwcil-Resource-MA Legislator.xlsx (66.4 KB, 12 views)
Reply With Quote