If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|