Sending an Outlook Template from buttons on Excel sheet

[Cagney]

I have an Excel sheet where i would like to set up a hyperlink or button that would send a specific Email Template to a specifc address.
I need to set up several of these hypelinks/Buttons on the same sheet.
Each button would send a different template to different addresses.
If this is poosible, any help/direction would be greatly appreciated.
Thank you.
BJ

 

[Gord Dibben]

I would start with checking out Ron de Bruin's articles on sending emails from
Excel.

http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx


Gord Dibben MS Excel MVP

 

[Cagney]

I would start with checking out Ron de Bruin's articles on sending emailsfrom
Excel.

http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx

Gord Dibben     MS Excel MVP





- Show quoted text -

Thank you for the link, but it primarily deals with sending the
existing SHEET that is currently open.
I need to know if/how VBA can send a specific Outlook Template. I
can't seem to find anything in the Help re this task, but thanks for
pointing me to the above link anyway.