Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I skip blank fields when mail merging?
My database has Address 1, Address 2 and Address 3, which I have to include
as separate lines in the merge document. But, I want to skip the lines if the merge fields are blank. How do I do that with Word 2003? |
#2
|
|||
|
|||
Lines that are blank as a consequence of containing merge fields whose
values are blank and nothing else should be suppressed by default. However, unlike Word 2000 and earlier those lines won't be suppressed if they are nested within another field such as an IF field. To change the setting manually, go to Tools|Options|Commands, select category All Commands, locate MailMergeHelper and drag it to a tool bar. Then use it and click the Merge button to find the option. Peter Jamieson "Phil" wrote in message ... My database has Address 1, Address 2 and Address 3, which I have to include as separate lines in the merge document. But, I want to skip the lines if the merge fields are blank. How do I do that with Word 2003? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove or supress blank data in fields in mail merge e.g. | Mailmerge | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Word 2002 Mail Merge - merging to new doc displays blank empty dia | Mailmerge | |||
Blank fields when mail merging | Mailmerge |