Excel - Sending an Outlook Template from buttons on Excel sheet

Asked By Cagney on 25-Feb-11 02:04 PM
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 replied to Cagney on 25-Feb-11 03:05 PM
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 replied to Gord Dibben on 28-Feb-11 09:24 AM
from
te:
that would send a specific Email Template to a specifc address.

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
cannot seem to find anything in the Help re this task, but thanks for
pointing me to the above link anyway.