Mail Merge Question

[AreaCode707]

Does anybody know how to do if-then logic in a mail merge so that if no response is returned, there are not paragraph marks left in the word doc?

Situation:
Doing a mail merge of a letter template with a big fricking spreadsheet. In the letter there are about 10 paragraphs in a row all based on if-then logic, where if data source = no, then do not input paragraph. The logic works fine.

The problem is that for each paragraph not input, there is a line break after the doc has been merged - an extra ten line breaks right in the middle of the completed letter.

Anybody have any help to offer?

 

[DaShen]

It may be better to do it in the query on the database side.

Make it so that the spreadsheet and mail merge point to a query which handles the null cases already.

Hope that helps.

 

[MikeyIs4Dcats]

try tek-tips.com

 

[DaShen]

Originally posted by: MikeyIs4Dcats
try tek-tips.com

I concur. But the query will work if that is what you need.