Help please.

The code below seeks to open a Word document, populate the Word document via the Mail Merge feature of Word, create a PDF, and save the PDF back to a shared drive. The Mail Merge data is contained in the open, and active, Excel document from which the macro is initiated.
The error I get when I run it (Object doesn't support this property or method) indicates a problem with the "wrdDoc.MailMerge.OpenDataSource..." statement.

Also, when the Word document is opened I get a message indicating it is currently locked by another user and gives me the choice to open it as read only. Can I make it stop asking me this? The Word document is NOT in use or open when I run the macro.

Thanks very much.


Please Login or Register  to view this content.