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

Sending e-mails from specific email address 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Prevent Sending eMail from Excel 3
export excel chart to image from C# without using interop 0
Sending mail with CDO through a remote SMTP server 2
trying to email workbook from VB6, getting error 1004 2
CDO, SMTP Server Name, and Excel's SendMail Method 4
Synchronization problems while moving folders to new email 1

Top