Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2014, 03:18 PM
macropod's Avatar
macropod macropod is offline Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Windows 7 32bit Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,525
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

For a label merge, you configure the first label exactly as you want, then click on the 'Update labels' button to propagate this setup to all the other labels. Then run your merge. Simple as that.



As for your custom layout, that would have to be done as a Word table, with the required number of columns & rows to more or less fill the page and with the cells positioned so the align with your label stationery (if that's what you're using).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 02-26-2014, 07:06 AM
brunofirst brunofirst is offline Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Windows 7 64bit Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Office 2010 64bit
Novice
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong?
 
Join Date: Jan 2014
Posts: 5
brunofirst is on a distinguished road
Default

Thanks!
Here's a follow-up someone may be able to help with...I've created my label template and want to know whether it's possible to save a template with text interspersed between mail merge fields. For now, each time I open my label template to complete a merge, I need to repopulate the first label with text, then manually insert each mail merge field. Is it possible to save a ready-to-go template, complete with fixed text and mail merge fields, so I can regularly import new data sets in the same way?
I haven't been able to find a similar-enough question on the boards, please let me know if you have a chance to help.
Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Mail Merge to label L7165X, record can't auto page to next 8 records stevencheng Mail Merge 3 09-29-2013 07:25 PM
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? MS Word 2007 mail merge. What about single contacts? bryankdonnelly Mail Merge 5 09-15-2013 03:43 PM
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? Mail merge going from the wrong account alexb123 Mail Merge 3 11-15-2011 11:49 PM
Mail Merge saved to single .pdf treetop Mail Merge 1 08-10-2011 03:28 PM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.


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