Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Terry the Terror Terry the Terror is offline
external usenet poster
 
Posts: 1
Default mailing labels blank fields

Can anyone tell me how to have a blank field skipped in a mail merge. I have
tried the Word Help but the field id still there. SOme addresses have detail
in the field and I want them to stay.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mailing labels blank fields

Use an If...then...Else field construction such as:

{ IF { MERGEFIELD fieldthatmightbeblank } "" "{ MERGEFIELD
fieldthatmightbeblank }¶
{ MERGEFIELD nextfield }" "{ MERGEFIELD nextfield }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and where
the ¶ appears in the above, press the Enter key (or Shift+Enter) to start a
new line.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Terry the Terror" Terry the wrote in
message ...
Can anyone tell me how to have a blank field skipped in a mail merge. I
have
tried the Word Help but the field id still there. SOme addresses have
detail
in the field and I want them to stay.



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
Mailing labels? Virginia Microsoft Word Help 2 July 17th 08 12:04 AM
Mailing Labels Charles Phillips Mailmerge 4 October 31st 06 12:02 AM
sheet of mailing labels with three columns, 10 labels per page virginia Mailmerge 2 August 25th 06 06:26 AM
Mailing Labels auction queen Mailmerge 1 June 28th 05 09:12 AM
mailing labels tedkilroy New Users 1 February 9th 05 11:09 PM


All times are GMT +1. The time now is 04:42 PM.

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

About Us

"It's about Microsoft Word"