 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2004mail merge labels
When creating labels using mail merge, there is one blank space before the name. All other lines of the address are properly aligned to the left. I'd appreciate any ideas. I've merged from Access and from Excel and I get the same space. What sort of space? Remove it before propogating the labels prior to running the merge - see http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When creating labels using mail merge, there is one blank > space before the name. All other lines of the address > are properly aligned to the left. I'd appreciate any > ideas. I've merged from Access and from Excel and I get > the same space. Hi Ruth, > When creating labels using mail merge, there is one blank > space before the name. All other lines of the address > are properly aligned to the left. I'd appreciate any > ideas. I've merged from Access and from Excel and I get > the same space. Are you sure there's not a space in the data, itself? And no space before the merge field in the main merge document? Which version of Word? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) This problem sounds similar to mine. In your template, do you have prefix, first name, and last name? If you have all three, are you getting data into all three fields? Your template may look like this: «Prefix» «FirstName» «tLastName» Notice the space between prefix and firstname as well as one between first and last name. If there is no data to fill in prefix the space remains. My qestion is asking how you can conditionally format the template to remove the space if their is no prefix present in the data. Is this similar to what you are experiencing? TampaMac > When creating labels using mail merge, there is one blank > space before the name. All other lines of the address > are properly aligned to the left. I'd appreciate any > ideas. I've merged from Access and from Excel and I get > the same space. That is easy to arrange with a conditional field which places the mergefield and its following space only when it has content eg {IF {Mergefield Prefix} <> "" "{Mergefield Prefix} "}{Mergefield FirstName}etc ie {IF {Mergefield Prefix} <> "" "{Mergefield Prefix}<space here> "}<no space here>{Mergefield FirstName}etc Use ALT+F9 to toggle the field display and CTRL+F9 to insert field boundaries. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > This problem sounds similar to mine. In your template, do you have > prefix, first name, and last name? If you have all three, are you [quoted text clipped - 14 lines] >> ideas. I've merged from Access and from Excel and I get >> the same space. I am having the exact same problem. Using Word 2003. Using Word table data files that have been updated and working fine for over 10 years, the switch from Word 2000 to Word 2003 has resulted in unusable labels...I have the space problem mentioned below, random missing address lines, extra spaces galore, etc. I also have tried massaging the data to Access & Excel, then back to Word and have only ended up with the same or similar problems. I'd hate to have to do a parallel install of Office/Word 2000 just to print labels. >-----Original Message----- >When creating labels using mail merge, there is one blank >space before the name. All other lines of the address >are properly aligned to the left. I'd appreciate any >ideas. I've merged from Access and from Excel and I get >the same space. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.