Macro to automate Mail Merge timing-out

Once a month, a colleague of mine uses a Mail Merge template I created to send out statements to all clients. He's less computer savvy than I am, and his lack of understanding is causing discomfort with him using that Mail Merge tool, but the alternative (manual entry) would be even more prone to human error and be far too time consuming. I've written a macro to automate the process of completing the Mail Merge - the idea is my colleague should be able to click a button from the workbook containing the data and not have to worry about following the step-by-step process or screwing it up again.

The macro I wrote starts working fine, but then it fails in the middle of it, anywhere from record 120 to record 180 (out of around 200 total). I receive an error message on the .Execute command that completes the merge, and that error message is "Run-time error 5535: Word could not finish merging these documents or inserting this database." It is failing on a different record each time I test it, so I don't think it has anything to do with syntax. It seems to be timing out, and I'm not sure how to allow more time to complete the merge. An alternative would be to split it into two macros, with the first handling records 1-100 and the second one handling records 101+, but that is not ideal.

Any advice would be much appreciated!

-KF

Please Login or Register  to view this content.