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

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

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx


Gord Dibben MS Excel MVP

On Fri, 25 Feb 2011 11:04:07 -0800 (PST), Cagney wrote:

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

On Feb 25, 3:05*pm, Gord Dibben wrote:
I would start with checking out Ron de Bruin's articles on sending emails from
Excel.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Gord Dibben * * MS Excel MVP



On Fri, 25 Feb 2011 11:04:07 -0800 (PST), Cagney wrote:
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- Hide quoted text -

- 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.