Mail Merge

[bradford white]

I am trying to do a complicated Mail Merge

There are columns from excel that have data in them. 9 Columns may or may
not have detail information included. I would like to set up that if there
is no data that the section is skipped until there is a cell that has data
included.

The beginning and end of the file will have standard data. The customer's
have various program options that need to be included.

there are about 300 varieties. trying to figure out how to do in a mail
merge and not have to do each individually.

I do not know word well or VBA at all.

Is it possible to set up to skip if cell from the data source is blank?

 

[Doug Robbins - Word MVP]

I am not sure from your description, but it could be that fellow MVP
Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue Mailmerge.zip

does what you want.

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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

 

[macropod]

Hi bradford,

If a mergefield is empty, Word ordinarily leaves its position blank. However, depending on how your document is formatted, you may
end up with an unwanted empty paragraph, line or space that is meant to separate that field from the one following. To overcome
this, you can use an IF test-

Mailmerge Empty Space Suppression
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 around the new field braces so that you end up with {IF«MyData»= "" "" "«MyData» "};
.. delete the space after the field;
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Mailmerge Empty Line Suppression
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