[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Labels Avery 5267, 80 per sheet

Posted on 2013-10-25
Medium Priority
Last Modified: 2013-11-08
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.
Question by:frugalmule
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 76

Assisted Solution

GrahamSkan earned 2000 total points
ID: 39602309
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.

Author Comment

ID: 39602332
Could you do four lines and post result?
LVL 76

Assisted Solution

GrahamSkan earned 2000 total points
ID: 39602475
You need to set the font size to 5 points to get four lines of text on each label.

The main document is attached.

Author Comment

ID: 39602871
Ok, so to change to 3 line format, I just need to change the point size back to 8?
LVL 76

Accepted Solution

GrahamSkan earned 2000 total points
ID: 39602924
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.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question