Macro to send from non-default email address

[k.n.]

Hi,



I need to send a mail merge (using Word 2010) from an email account that I have permissions set up to send from, but is not my default. I've read around and it seems this is no longer possible with Word 2010, unless you use a macro. Does anyone have a template for this macro that I can use/adapt?

It needs to send an email from xyz@example.com with a subject line and the body of the email needs to contain fields from the Excel spreadsheet, as you'd expect!

Thank you