Send e-Mail from Excel without Dialog

D

davenews

I know how to use the Sendmail method to send an email from Excel, but
this always makes it necessary for the user to click "Send" to actually
send the file or message. Does anyone know of a way to send an email
from Excel automatically without any user feedback? I've looked a
little at cdo but can't seem to get it to work. Any ideas would be
greatly appreciated.
 
J

Jake Marx

davenews said:
I know how to use the Sendmail method to send an email from Excel, but
this always makes it necessary for the user to click "Send" to
actually send the file or message. Does anyone know of a way to send
an email from Excel automatically without any user feedback? I've
looked a little at cdo but can't seem to get it to work. Any ideas
would be greatly appreciated.
Click to expand...

Did you look at Ron de Bruin's site?

http://www.rondebruin.nl/cdo.htm

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to email workbook from VB6, getting error 1004 2
Sending e-mails from specific email address 2
CDO, SMTP Server Name, and Excel's SendMail Method 4
Prevent Sending eMail from Excel 3
e-mail 7
Send Mail using Lotus Notes 1
Access Automatically Send a notification email once a record is added 0
export excel chart to image from C# without using interop 0

Top