 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2007In Word 2003 when mail merge how do I delete an empty field?
When a defined field is blank how do I tell mail merge to skip that field on that one merge? By blank do you mean empty? If so you can conditionally insert the content of that field eg {IF{Mergefield fieldname} <> "" "{Mergefield fieldname}"}  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When a defined field is blank how do I tell mail merge to skip that > field on that one merge? Yes, I do mean empty. However, the situation would be, for example, in my mail merge I have a field for "name". The mail merge is set up with a line stating Attn: <name> Some records do not have an entry for name and on the mail merge if the <name> field is empty I want that line skipped in the merge ie do not print the word Attn. > By blank do you mean empty? If so you can conditionally insert the content > of that field eg [quoted text clipped - 3 lines] > > When a defined field is blank how do I tell mail merge to skip that > > field on that one merge? It is then but a small stretch to something like: {Mergefield Company}{IF{Mergefield name} <> "" "Attn: {Mergefield fieldname} "}{Mergefield Address1}etc Use CTRL+F9 for the brackets {} and substitute the correct field names Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Yes, I do mean empty. However, the situation would be, for example, > in my mail merge I have a field for "name". The mail merge is set up [quoted text clipped - 17 lines] >>> When a defined field is blank how do I tell mail merge to skip that >>> field on that one merge? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.