Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO, SMTP Server Name, and Excel's SendMail Method
I have an Excel VBA macro that sends mail using CDO. Works fine, but
users have to enter their SMTP Server in a designated cell. In case a user doesn't know his SMTP Server, I allow the user to choose, in a dropdown, whether to use CDO or Excel's SendMail, since Excel's SendMail Method does not require specifying an SMTP Server. Instead, according to the function reference, it uses "the installed mail system" to send mail. But CDO is much more versatile than Excel's SendMail, so I'd prefer to be able to use CDO without expecting the user to know his SMTP Server. Obviously, Excel's SendMail is somehow figuring out the SMTP Server. I've found code to do this if the user has a mail account set up in Outlook Express, but whatever Excel does works with or without an Outlook Express mail account set up. If Excel can do it, surely it must be possible to do it in another program too. How can I determine the SMTP Server without regard to what mail program is installed and set up with a mail account? Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To send an email to a remote SMTP server | Excel Programming | |||
smtp server | Excel Programming | |||
How 2 remove this error - SMTP Server, Email using CDO | Excel Programming | |||
CDO_send can't communicate with smtp server | Excel Programming | |||
SendMail Method | Excel Programming |