Thread: Send email using Active Cell but using external Outlook / Livemail template

Greetings from a Newb in Arizona.

First of all, please forgive my Naiveté and the fact that this question has likely already been asked or that this may be a question better suited for an Outlook board (who? where?).

I use excel spreadsheets that include names, addresses, email addys, etc. I have also created a 'default template' for Outlook that already has the subject, message I want to send and the (default) appropriate files I want to attach.

My need is this: I want to arrow down to a cell (where-ever in the spreadsheet it happens to reside) that has a customer's email addy. I then want to run a macro that uses that Active Cell, calls up the default email program and uses a SPECIFIC mail template.

Am I even making sense? Yes, I know that if I simply CLICK on the whomever@whereever.com cell it will open a BLANK email message, but I need it to open a SPECIFIC outlook template depending on the macro I choose.

ie, if I want to send sales files to this particular addy, I go to the addy, run the macro SALES, and that opens the Sales external (outlook, etc) template using the addy in the Active Cell. However, if I want to send Info (rather than sales stuff), then i run a different macro, INFO, and that opens a *different* external email template using this addy.

your response either on this board or directly to me ( sellen at aol dot com) would be GREATLY appreciated!

Regards,

Scott,
Lake Havasu City, AZ