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