setting a condition in mail merge

C

Candice

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!!!
 
G

Graham Mayor

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

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top