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 |