 |
 | 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 / January 2007How do I limit text output from a merge field?
Hi; This seems like it should be a very easy thing to do. In Access, I put both the First Name and Middle Initial into the "First Name" field. When I print my advertisements using Word Mail Mere, I want only the first name to appear, ignoring the initial. I am guessing there is an "If/ Then" statement or something that I can insert that will have mailmerge only use the letters before the space, but I can't figure out how to do that. Of course, I could make a middle initial field in Access, and just might do that. I was just curious and would like to learn more of this aspect of mail merge anyway. Thanx Jdaman It's all the field or nothing - split the field in your data source.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi; > This seems like it should be a very easy thing to do. In Access, I [quoted text clipped - 8 lines] > Thanx > Jdaman It would appear you are correct. It is not a large database, so adding the new column and separating the middle name to its own field did not present a problem. Also, how do you use the format feature in the Address Block screen? Thanx, J > It's all the field or nothing - split the field in your data source. > [quoted text clipped - 18 lines] > > Thanx > > Jdaman Don't even try. The address block field causes more problems than it solves. Use the individual fields presented in whatever way you require. You can conditionally insert the initial field to avoid unwanted spaces eg {Mergefield FirstName}{IF {Mergefield Initial} <> "" " {Mergefield Initial}."} {Mergefield LastName} Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > It would appear you are correct. It is not a large database, so > adding the new column and separating the middle name to its own field [quoted text clipped - 24 lines] >>> Thanx >>> Jdaman |
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.