Labels Avery 5267, 80 per sheet

I've tried Mail Merge using MS Word 2013 with the attached Excel file and am having all kinds of trouble getting them to look right.  I've even tried downloading the tool from Avery and apparently my version of Office is too new for it.

Assistance in getting these labels right would be greatly appreciated.
131017-Companies.xlsx
frugalmuleAsked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
Yes. It's simply a matter of how much space the text takes up. The table that represents the labels has fixed row heights and column widths so cannot show excess text.

Select the whole document and choose 8 in the font size box.
0
 
GrahamSkanConnect With a Mentor RetiredCommented:
You don't say what the problem actually is, but the labels themselves are very small with a height of only 1.27 cm.

However I was able to get three lines of the address in to fit by setting the font size to 8 points in the document.

Note that the default transfer method (ODBC) for mail merge since Office 2000 copies data only, so the 8 point setting in the spreadsheet has no effect on the merge document.
0
 
frugalmuleAuthor Commented:
Could you do four lines and post result?
0
 
GrahamSkanConnect With a Mentor RetiredCommented:
You need to set the font size to 5 points to get four lines of text on each label.

The main document is attached.
City-of-Waco5pt.docx
0
 
frugalmuleAuthor Commented:
Ok, so to change to 3 line format, I just need to change the point size back to 8?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.