By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,916 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,916 IT Pros & Developers. It's quick & easy.

Second Mail-Merge document doesnt get created

P: 1
Hi all, Im facing issues in generating the second mail-merge document when the first document created is still open.

Its a web based application, and we submit the details for mail-merge after which document gets created.

Im using VBA code to do mail-merge functionality. When I run the application the first time word document gets created (for 1 row and n rows - based on the number of records returned from database, so many pages / form-letters are created in a single document).

When I keep this word document open and try to run the web-application the second time, mail-merge document doesnt get created rather only an empty document gets created, but if I click on the new document (activate it) within 5 seconds the macro gets downloaded properly and document is created.

I have set the document Activate property.
Set oCodeDoc = Application.ActiveDocument
oCodeDoc.Activate

Can someone help me with this issue, thanks.
Jun 14 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.