 |
 | 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 2008Using a function in Mailmerge
Office 2007. I'm doing a mailmerge using an Excel spreadsheet via OLE. I've got a field that contain's a person's name, and am trying to find an easy way to deal with text in the possessive form. For example: { MERGEFIELD Person }'s belongings generates Bill's belongings Morris's belongings etc. The problem is that I'd like "Morris's" to become "Morris'". If I could just test for RIGHT({ MERGEFIELD Person },1)="s" that would do the trick. But I can't find any way to do it. Of course I could accomplish this in Excel and pass another field to Word, but I'm trying not to. Sadly there are no RIGHT, LEFT, MID, LEN, INSTR etc functions associated with fields (though they have been requested) so your choices are to add another field to your data source or use conditional fields to cover all such names you know to be in the date source.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Office 2007. I'm doing a mailmerge using an Excel spreadsheet via > OLE. I've got a field that contain's a person's name, and am trying [quoted text clipped - 8 lines] > accomplish this in Excel and pass another field to Word, but I'm > trying not to. On further reflection, the following may be sufficient to do what you want: { IF { Mergefield Person } = "*s" "{ Mergefield Person }'" "{ Mergefield Person }' s"} Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Office 2007. I'm doing a mailmerge using an Excel spreadsheet via > OLE. I've got a field that contain's a person's name, and am trying [quoted text clipped - 8 lines] > accomplish this in Excel and pass another field to Word, but I'm > trying not to. Brilliant! It did just what I was looking for. Thanks for the help. > On further reflection, the following may be sufficient to do what you want: > [quoted text clipped - 13 lines] > > accomplish this in Excel and pass another field to Word, but I'm > > trying not to. You are welcome :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Brilliant! It did just what I was looking for. Thanks for the help. > [quoted text clipped - 24 lines] >>> accomplish this in Excel and pass another field to Word, but I'm >>> trying not to. |
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.