| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Mail Merge with Excel Data
In Word XP, if some of the data fields have blanks (i.e. Address 1 but
Address 2 does not include anything), how do I configure the Mail Merge instructions to disregard the blank fields without leaving a blank line in its place? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Using Mail Merge with Excel Data
Use nested IF fields that insert the data /and/ a paragraph mark if the
field is not blank, but insert nothing if the field is blank. Like this: { IF { MERGEFIELD field1 } "" "{ MERGEFIELD field1 } " "" }{ IF { MERGEFIELD field2 } "" "{ MERGEFIELD field2 } " "" } Peter Jamieson http://tips.pjmsn.me.uk On 12/04/2010 15:58, Renegade wrote: In Word XP, if some of the data fields have blanks (i.e. Address 1 but Address 2 does not include anything), how do I configure the Mail Merge instructions to disregard the blank fields without leaving a blank line in its place? |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Using Mail Merge with Excel Data
Use nested IF fields that insert the data /and/ a paragraph mark if the
field is not blank, but insert nothing if the field is blank. Like this: { IF { MERGEFIELD field1 } "" "{ MERGEFIELD field1 } " "" }{ IF { MERGEFIELD field2 } "" "{ MERGEFIELD field2 } " "" }{ IF { MERGEFIELD field3 } "" "{ MERGEFIELD field3 } " "" } Peter Jamieson http://tips.pjmsn.me.uk On 12/04/2010 15:58, Renegade wrote: In Word XP, if some of the data fields have blanks (i.e. Address 1 but Address 2 does not include anything), how do I configure the Mail Merge instructions to disregard the blank fields without leaving a blank line in its place? |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Using Mail Merge with Excel Data
Use nested IF fields that insert the data /and/ a paragraph mark if the
field is not blank, but insert nothing if the field is blank. Like this: { IF { MERGEFIELD field1 } "" "{ MERGEFIELD field1 } " "" }{ IF { MERGEFIELD field2 } "" "{ MERGEFIELD field2 } " "" }{ IF { MERGEFIELD field3 } "" "{ MERGEFIELD field3 } " "" } etc. All the {} need to be the special field brace pairs that you can insert using ctrl-F9 Peter Jamieson http://tips.pjmsn.me.uk On 12/04/2010 15:58, Renegade wrote: In Word XP, if some of the data fields have blanks (i.e. Address 1 but Address 2 does not include anything), how do I configure the Mail Merge instructions to disregard the blank fields without leaving a blank line in its place? |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Using Mail Merge with Excel Data
Sorry about the repeated post!
Peter Jamieson http://tips.pjmsn.me.uk On 12/04/2010 15:58, Renegade wrote: In Word XP, if some of the data fields have blanks (i.e. Address 1 but Address 2 does not include anything), how do I configure the Mail Merge instructions to disregard the blank fields without leaving a blank line in its place? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge with excel data | Mailmerge | |||
| mail merge and excel data | Mailmerge | |||
| Mail merge with excel data | Mailmerge | |||
| Mail Merge with Excel Data | Mailmerge | |||
| MAIL MERGE USING EXCEL DATA | Mailmerge | |||
Hybrid Mode
