Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2016, 10:28 AM
Costco25 Costco25 is offline Label Mail Merge Windows 10 Label Mail Merge Office 2013
Novice
Label Mail Merge
 
Join Date: Dec 2016
Posts: 1
Costco25 is on a distinguished road
Default Label Mail Merge

Imported my 7 Christmas names and addresses from word into mail merge using the template Avery 8161. Each page is 20 labels. It creates 7 pages. The first with all 7 listings, the second with 6, the third with 5, and the last or 7th page with 1.
How do I import so all names and addresses are listed for printing just once?
Reply With Quote
  #2  
Old 12-01-2016, 03:25 PM
macropod's Avatar
macropod macropod is offline Label Mail Merge Windows 7 64bit Label Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Evidently, you haven't done the setup and execution correctly. First, make sure your mailmerge main document has only one page of labels. Next, check that the mailmerge type is set to 'label'. Then, assuming you have the first label formatted as you want all lables to appear, clikc on 'update labels'. Finally, click on 'Finsih & Merge' to complete the process - mailmerge previews are not a reliable indicator of the final output. That said, for a simple label merge with few records, a preview starting from the first record should display all of the records on a single page.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Label Mail Merge Editing a mail merge label Colonel Biggs Word 6 03-22-2015 07:09 AM
Label Mail Merge How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM
Label Mail Merge Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? brunofirst Mail Merge 7 02-27-2014 02:30 PM
Label Mail Merge Mail Merge to label L7165X, record can't auto page to next 8 records stevencheng Mail Merge 3 09-29-2013 07:25 PM
Label Mail Merge Label merge sulasno Mail Merge 2 03-16-2011 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft