Home |
Search |
Today's Posts |
#1
|
|||
|
|||
setting a condition in mail merge
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!!! -- Candice |
#2
|
|||
|
|||
{IF {Mergefield FirstName} "" "{Mergefield FirstName}" "{Mergefield
Company}"} Insert all the curly field brackets with CTRL+F9 and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Candice wrote: 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 alternate mergefield? Example: my spreadsheet has FirstName, LastName, Company...If the FirstName is blank then fill in with Company Name? Please Help!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge if ... then else condition | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |