Extra pages added at end of VBA mail merge

Hi All,

Might not be the best place to post this, but perhaps someone may be able to give some insight or help. I have a excel logsheet filling a MS Word template for a report. The data transfers to the Word document properly, but as the code runs, it seems to add blank template pages to the end of the Word document. So, instead of a 2 page document being saved, there is 2 pages of data followed by about 50 copies of the blank template. I have looked at the Word Template for format markers that may be adding page breaks or something where I was not expecting it. I didn't see anything out of the ordinary.

Here is the code for the mail merge. I had used this in the past on other things without issue, after making file location changes and what not.

Please Login or Register  to view this content.

If I step into the code, I can see the pages adding to the Word Document at the last End With.


As always, thank you for what help you may give.


Patrick

Dflak,

Thanks for asking the right question. I found an active cell on row 205. After deleting rows from the end of my data to that active cell, the problem corrected.

Many thanks for your help.

Patrick