Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jflowers jflowers is offline
external usenet poster
 
Posts: 1
Default how do i remove blank lines in mail merge address labels

I am using word 2003 to do a address labels using mail merge. My data source
is in an excel spread sheet. The problem is that some of the addresses
contain a 2nd line for apt# and some don't? when the merge is complete it
leaves blank lines if there is noothing in the field. How can I get the merge
to reconize that is a field is empty and does not need a space?
  #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 how do i remove blank lines in mail merge address labels

Use an If...then...Else field construction, using Ctrl+F9 to insert each
pair of field delimiters

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD Address1 }" "{ MERGEFIELD
Address1 }¶
{ MERGEFIELD Address2 }" }

where the ¶ appears in the above, press Enter or Shift +Enter

Use Alt+F9 to toggle off the display of the field codes.

--
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, originally posted via msnews.microsoft.com

"jflowers" wrote in message
...
I am using word 2003 to do a address labels using mail merge. My data
source
is in an excel spread sheet. The problem is that some of the addresses
contain a 2nd line for apt# and some don't? when the merge is complete it
leaves blank lines if there is noothing in the field. How can I get the
merge
to reconize that is a field is empty and does not need a space?


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
How do I remove blank lines in mail merge labels in Word 2003 Islandtop Mailmerge 2 December 7th 07 06:24 PM
eliminate blank lines in mail merge address block dahl1gen Mailmerge 1 December 4th 07 09:25 PM
How do I suppress blank address lines in Word2003 mail merge? JonUK5691 Mailmerge 1 March 22nd 05 09:31 PM
How to I delete blank lines/labels in the mail merge function? Suzieq Mailmerge 2 December 17th 04 03:21 AM
suppressing blank address lines in mail merge Geoff Holt Mailmerge 1 November 26th 04 07:16 PM


All times are GMT +1. The time now is 07:20 PM.

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"