 |
 | 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 / May 2005If data the same Disregard
Using Office 2002 Using Excel as the data source, I am putting together through Word's mailmerge, a list containing: LastName, FirstName, MaidenName If the LastName and the MaidenName are the same I do not want the Maiden Name data merged, and the table cell to be blank. Is there a simple way to do this?  SignatureRegards Michael Koerner Use an If...then...else field that compares the MaidenName to the LastName and only prints it if it is different SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Using Office 2002 > [quoted text clipped - 7 lines] > data merged, and the table cell to be blank. Is there a simple way to do > this? It would, if I knew how to write that stuff. SignatureRegards Michael Koerner Use an If...then...else field that compares the MaidenName to the LastName and only prints it if it is different SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Using Office 2002 > [quoted text clipped - 7 lines] > data merged, and the table cell to be blank. Is there a simple way to do > this? {IF {Mergefield LastName} <> {Mergefield MaidenName} "{Mergefield MaidenName}"} You need to create the above using CTRL+F9 for each pair of field brackets. Put in the MaidenName cell this will only enter content if the fields have different content. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > It would, if I knew how to write that stuff. > [quoted text clipped - 23 lines] >> Regards >> Michael Koerner Many thanks SignatureRegards Michael Koerner {IF {Mergefield LastName} <> {Mergefield MaidenName} "{Mergefield MaidenName}"} You need to create the above using CTRL+F9 for each pair of field brackets. Put in the MaidenName cell this will only enter content if the fields have different content. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Michael Koerner wrote: > It would, if I knew how to write that stuff. > [quoted text clipped - 25 lines] >> Regards >> Michael Koerner Michael, Have you tried? Something like: {IF {Mergefield "MaidenName"}<>{Mergefield "LastName"}{Mergefield "MaidenName"}""} I did, works well, thanks to Graham Mayor. I notice that your code although similar to his has "" around all the Mergefield names. Is there an advantage to this? SignatureRegards Michael Koerner Michael, Have you tried? Something like: {IF {Mergefield "MaidenName"}<>{Mergefield "LastName"}{Mergefield "MaidenName"}""} Michael, No advantage that I know of and it might not even work. I didn't have a document to test with and I guessed if the speech marks were required or not. Graham's method is probably best. I'll have to try it out and see. Seems to me I read somewhere that it was acceptable both ways. Thanks again. SignatureRegards Michael Koerner Michael, No advantage that I know of and it might not even work. I didn't have a document to test with and I guessed if the speech marks were required or not. Graham's method is probably best. |
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.