Send mail from Excel

S

Steve C.

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.
 
B

Bob Phillips

Don't know the answer, but you could create an environment variable and read
that in the program.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top