Hello,
I am using Excel and Word 2007. I have a macro that starts in Excel and then moves to Word. I have a list of references in Excel, and then there is a macro in Excel that causes Word to open and automatically run a Mail Merge with those references. The Word document has a logo in the footer, but after running the macro in Word, the logo disappears. Or, I should say it turns into one of those pesky little red Xs. If I simply open the Word document and run the Mail Merge manually, the logo is fine, so I'm assuming this is a problem with the macro. Also, this is a new issue and the macro used to run fine without affecting the logo.
Here is my Excel code:
And here is my Word code:
Anyone have any suggestions?
Thanks,
AJO
Bookmarks