Executing a Mail Merge with An Embedded Word File

[GazB]

Hi All,

I'm having some trouble performing a mail merge using an embedded Word file. Essentially I'm trying to build a macro to:

• Open an embedded Word file (let's say the file is Object(2))
• Connect the Export sheet to the word fie
• Preview the results
• Update the table of contents
• Export the file as a PDF
• Close the word application leaving the completed PDF open

Here's the code I have so far but it doesn't work. Could anyone help me with where I'm going wrong? It opens the embedded word object in MS Word 2007 and also opens a MS Word 97 application but that's it!

Please Login or Register  to view this content.

Thanks
Gareth

[GazB]

Forgot to mention, I would prefer the operation to be invisible to the user (i.e. visibility of the word application non-existent!)

Thanks

[GazB]

Ok so I've got it to a point where it'll complete everything apart from destroying the WINWORD.exe process. Any ideas?

Please Login or Register  to view this content.

[GazB]

Anyone have any cluses on this one. Still can;t get WINWORD.exe to close?

Cheers
Gareth