Word Mail Merge

[Saps]

i have setup a mail merge document in word. why does it continually print out blank pages?

 

[Marbles]

How many fields do you have in your document?
The blank pages might be records with no data in the fields you are using. Or maybe the original document might have a blank page and is being printed with every merged record.

 

[Saps]

They the number of records does match the number of pages. Any ideas on how to stop this?

 

[Marbles]

If the number of records matches the number of pages, then it does sound like the blank pages might be records with no data in the fields you are using.

What you could do is go to Mail Merge Recipients and look to see if there are records where all your fields are empty.

What fields are they?

 

[Saps]

Well, I am actually doing this from excel with code. But I can't seem to find any code that will take care of the blanks. I can do it manually going into my template though.