Send mail from Excel
Hi,
I'm writing some codes that allow users to send e-mail
from Excel using CDO object. To make it work, I need to
provide the name of the SMTP server and I don't want to
hard code it in the program. I wonder is that any
functions that can get the SMTP server name in VBA so that
I can incorporate it in my codes?
Your help is much appreciated!
Regards,
Steve C.
|