|
| 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
April 12th, 2010, 03:58 PM
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
April 12th, 2010, 06:58 PM
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
April 12th, 2010, 06:59 PM
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
April 12th, 2010, 07:00 PM
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
April 12th, 2010, 08:30 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
