Mail merge

[bam12]

I am using an excel file to do mail merge. The problem I am having is when I try to edit the mail merge it prints 130 pages almost all the time. The mail merge can be 20 pages but still print more then that when I edit it. The edit file makes a new file and that is the one that print the pages.

TIA for any help

 

[Macropod]

Hi bam12,

The problem will be caused by having active rows in your worksheet after the last data row. Use Ctr-End to go to the last used cell, then select all rows from there till the first row following the last data row and delete the entire rows (not just the unused cells).

 

[Derek Brown]

I agree with Paul about the most likely cause.
Have a look at the following solutions suggested by Microsoft:
http://support.microsoft.com/kb/244435
(I have used the add-in.)