Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-31-2014, 08:27 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 Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong?

Hi: I'm hoping to get some help re: my inconsistent (but always unsuccessful) attempts to create Mail Merge labels in MS Office 2010.


The labels I need to create require additional text surrounding the Merge Fields, ex.: Title: <<title>> or Reproduction source: <<column K>>. I assume this is possible because people must use Mail Merge to print envelopes with fixed return addresses, or things with the words "To:" and "From:," etc.


I've created a custom layout to match the non-standard-size labels I need to print and created an Excel file with the columns of text I need to import.




When I use Mail Merge wizard, one of the following problems occurs:


1) I cannot save a template of the labels I need with the built-in text included (I've tried opening both a template and a document of the label grid, then pasting the text onto the first cell so it'll get copied into the <<Next Record>> spaces.
2) Even though there are 6 labels/page, if Mail Merge does work, it'll import text into the first label of each page, NOT consecutively into each label.
3) Lastly, I'll get everything arranged and looking OK, then click "Preview results," and all the Merge Fields disappear and NO text is imported.


Hoping this question is laid out clearly enough. I'm at a complete loss for what I'm doing wrong, grateful for any help, suggestions, etc. anyone may have; please let me know if there's more information I can provide.


Thanks.
Reply With Quote
 

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 11:21 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