[YK]

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

[Peter Jamieson]

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

"YK" wrote in message
...
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