Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Renegade Renegade is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge with excel data trr Mailmerge 1 October 7th 08 08:19 PM
mail merge and excel data sherobot Mailmerge 2 April 23rd 07 08:08 PM
Mail merge with excel data bronxbabe Mailmerge 4 December 6th 06 04:21 AM
Mail Merge with Excel Data Jonathan L. Mailmerge 1 August 5th 06 08:33 PM
MAIL MERGE USING EXCEL DATA lfaraglia Mailmerge 4 January 26th 05 09:59 PM


All times are GMT +1. The time now is 02:38 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"