Mail Merge how do you leave a blank line for items with no value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

YK - 28 Sep 2006 16:15 GMT

I am trying to merge an Excel data source using mail merge. The output
should be 8 lines each, even if there is no value in the data fields. How do
we leave a blank line for data items with no value

Reply to this Message

Peter Jamieson - 28 Sep 2006 18:10 GMT

Can you say a bit more about
a. your version of Word/Excel
b. what kind of merge? "Letter", or "Directory" (or "Catalog")
c. how you are laying out your merge fields in your mail merge main
document?

Peter Jamieson

>I am trying to merge an Excel data source using mail merge. The output
> should be 8 lines each, even if there is no value in the data fields. How
> do
> we leave a blank line for data items with no value

Reply to this Message

Rate this thread: