View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge how do you leave a blank line for items with no value?

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