Solved

Labels Avery 5267, 80 per sheet

Posted on 2013-10-25
5
620 Views
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.
131017-Companies.xlsx
0
Comment
Question by:frugalmule
  • 3
  • 2
5 Comments
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 500 total points
Comment Utility
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
 

Author Comment

by:frugalmule
Comment Utility
Could you do four lines and post result?
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 500 total points
Comment Utility
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
 

Author Comment

by:frugalmule
Comment Utility
Ok, so to change to 3 line format, I just need to change the point size back to 8?
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
Comment Utility
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now