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

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

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

{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

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

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?

--

Regards
Michael Koerner


"Greg" wrote in message
oups.com...
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.

--

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.