A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I remove spacing from mail merge fields with no data



 
 
Thread Tools Display Modes
  #1  
Old September 14th, 2009, 11:57 PM posted to microsoft.public.word.mailmerge.fields
Jamie
external usenet poster
 
Posts: 317
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  
Old September 15th, 2009, 01:49 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
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 ..


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.