Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jamie Jamie is offline
external usenet poster
 
Posts: 45
Default How do I remove spacing from mail merge fields with no data

I am using mail merge to create a document with 500 recipiants, not all
recipiants listed have all fields filled in. This creates a blank line. How
do i remove this.

Can anyone help please ..
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How do I remove spacing from mail merge fields with no data

Hi Jamie,

In Word:
.. duplicate the mailmerge field to be suppressed (eg «MyData») so that you get «MyData»«MyData»;
.. select both fields and Press Ctrl-F9 to enclose them in a new field, thus { «MyData»«MyData» };
.. fill in between the braces so that you end up with {IF«myData»= "" "" "«MyData»¶
"}, where the '¶' is a paragraph mark or line-feed, depending on which you're using;
.. delete the existing paragraph mark or line-feed after the field;
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.


--
Cheers
macropod
[Microsoft MVP - Word]


"Jamie" wrote in message ...
I am using mail merge to create a document with 500 recipiants, not all
recipiants listed have all fields filled in. This creates a blank line. How
do i remove this.

Can anyone help please ..


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
Remove character limit in mail merge fields. bhodge Mailmerge 6 April 27th 23 02:59 PM
Too Many Data Fields in Mail Merge Lynda[_2_] Mailmerge 9 May 16th 07 09:11 AM
Data fields in mail merge Lighthouse Mailmerge 1 December 8th 05 06:56 PM
How can I add data fields to a data source in Word Mail Merge? cd Mailmerge 2 November 7th 05 06:41 PM
How do I remove or supress blank data in fields in mail merge e.g. J&L Mailmerge 2 January 14th 05 06:04 AM


All times are GMT +1. The time now is 05:40 AM.

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"