Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Labels Avery 5267, 80 per sheet

Posted on 2013-10-25
5
Medium Priority
?
778 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 77

Assisted Solution

by:GrahamSkan
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.
0
 

Author Comment

by:frugalmule
ID: 39602332
Could you do four lines and post result?
0
 
LVL 77

Assisted Solution

by:GrahamSkan
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.
City-of-Waco5pt.docx
0
 

Author Comment

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

Accepted Solution

by:
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

564 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