setting a condition in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candice - 06 May 2005 00:21 GMT

How do I set a condition so that when I do the mail merge....if one
mergefield is blank from my data source I want it to fill in with an
atlernate mergefield? Example: my spreadsheet has FirstName, LastName,
Company...If the FirstName is blank then fill in with Company Name?

Please Help!!!

Signature

Candice

Reply to this Message

Graham Mayor - 06 May 2005 06:12 GMT

{IF {Mergefield FirstName} <> "" "{Mergefield FirstName}" "{Mergefield
Company}"}

Insert all the curly field brackets with CTRL+F9 and type the rest.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do I set a condition so that when I do the mail merge....if one
> mergefield is blank from my data source I want it to fill in with an
[quoted text clipped - 3 lines]
>
> Please Help!!!

Reply to this Message