Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If 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? -- Regards Michael Koerner |
#2
|
|||
|
|||
Use an If...then...else field that compares the MaidenName to the LastName
and only prints it if it is different -- Hope 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 "Michael Koerner" wrote in message ... 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? -- Regards Michael Koerner |
#3
|
|||
|
|||
It would, if I knew how to write that stuff.
-- Regards Michael Koerner "Doug Robbins" wrote in message ... Use an If...then...else field that compares the MaidenName to the LastName and only prints it if it is different -- Hope 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 "Michael Koerner" wrote in message ... 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? -- Regards Michael Koerner |
#4
|
|||
|
|||
{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. -- 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. -- Regards Michael Koerner "Doug Robbins" wrote in message ... Use an If...then...else field that compares the MaidenName to the LastName and only prints it if it is different Doug Robbins - Word MVP "Michael Koerner" wrote in message ... 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? -- Regards Michael Koerner |
#5
|
|||
|
|||
Many thanks
-- Regards Michael Koerner "Graham Mayor" wrote in message ... {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. -- 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. -- Regards Michael Koerner "Doug Robbins" wrote in message ... Use an If...then...else field that compares the MaidenName to the LastName and only prints it if it is different Doug Robbins - Word MVP "Michael Koerner" wrote in message ... 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? -- Regards Michael Koerner |
#6
|
|||
|
|||
Michael,
Have you tried? Something like: {IF {Mergefield "MaidenName"}{Mergefield "LastName"}{Mergefield "MaidenName"}""} |
#7
|
|||
|
|||
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? -- Regards Michael Koerner "Greg" wrote in message oups.com... Michael, Have you tried? Something like: {IF {Mergefield "MaidenName"}{Mergefield "LastName"}{Mergefield "MaidenName"}""} |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
I'll have to try it out and see. Seems to me I read somewhere that it was
acceptable both ways. Thanks again. -- Regards Michael Koerner "Greg" wrote in message oups.com... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Data Mess | Microsoft Word Help | |||
Word Field Codes in Excel data file | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
Merge Data Source path | Mailmerge |