How do I suppress blank lines in a Mail Merge?

S

susie

I am using Word 2003 to create letters using a database in Excel 2003, I have
numerous IF fields in the body of the main document. How do I suppress the
fields in the merged documents if they are blank? Have tried the Mail Merge
Helper, etc.
Thanks for any tips you can share.
 
B

Bob I

Open Word, click Help, Look up "mail-merge",

Click on "Troubleshoot mail merge"

Click on "My merged document has blank lines."

Follow instructions
 
S

susie

Thanks, that helped somewhat. When more than 1 field is blank, though, I
still get spaces...
 
B

Bob Buckland ?:-\)

Hi Susie,

You may want to use the link below to post your question directly to the MS Word Mailmerge newsgroup. When posting there include
the version of Word you're using, the type of merge and what you'd like to achieve vs what you're seeing.

======
Thanks, that helped somewhat. When more than 1 field is blank, though, I
still get spaces... >>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
S

susie

Thank you, I will try that.

Bob Buckland ?:-) said:
Hi Susie,

You may want to use the link below to post your question directly to the MS Word Mailmerge newsgroup. When posting there include
the version of Word you're using, the type of merge and what you'd like to achieve vs what you're seeing.

======
Thanks, that helped somewhat. When more than 1 field is blank, though, I
still get spaces... >>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP


LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
Click to expand...
 
Top