PDA

View Full Version : Emailing from Excel



ukdane
08-31-2009, 12:12 AM
The Setup.
I have a general question, about generating emails directly from within Excel. I'll be using Excel 2003, but I don't know what version of Excel each individual customer will be using.

I have an excel sheet that will be sent to our customers, they will have to press a button that will either accept, or decline the offer made in the excel sheet. In doing so, an email will be generated, with the relevant response.

This in iteslf is fine, and I know how to generate the email using Outlook.

The Question.
My question is this. Obviously, I don't know what email program each individual customer will be using.
Is there a generic way of creating an email, so that it will create a preprepared email resonse, regardless of what the customer is using, or is there some code I can use to "hit" as many email prgrams as possible (possibly by the program itself being able to deduce which Email program is in use).

Thanks for your help.

p45cal
08-31-2009, 02:06 AM
Have an explore of CDO, see recent thread, especially post #10 here:
http://www.vbaexpress.com/forum/showthread.php?t=28179