Hi All,

Just wondering if it is possible to use VBA to call upon an embedded Word Document to complete a Mail Merge within Excel, using the Excel Spreadsheet as the Data Source for the Mail Merge.

The Mail Merge would be used for emailing out to people.

I have been able to do everything with the VBA for the Mail Merge to work, and all of the code is fine - but the user would have to keep the Excel Spreadsheet with another folder that contains the Word Document that is used as a template for the Mail Merge. So I wanted to try to clean that up by having the Word Document embedded in the Excel Spreadsheet (this would also act as a fail safe to ensure that the Mail Merge function can still work if they decide to move the spreadsheet away from the folder with the Word Document in - as the VBA wouldn't know where the Word Document has gone to).

Hope you can help / just let me know if this wouldn't work.

I have read before now that when you embed a Word Document in Excel you only have rights to edit the document and nothing more, therefore something like Mail Merge and VBA wouldn't be an option.


Let me know if you need any more info.


Thanks



Ste