Sending mail from Excel with CDO - return SMTP value
 

I will use Ron de Bruin excellent code to send Excelsheets by mail with CDO.
The excel-sheet is used by different users with different SMTP server values,
so I cannot put a fixed value into the code.
Does anybody know the code to return the current SMTP value, so I can give
this value to a variable ?

Regards
Kent

Sending mail from Excel with CDO - return SMTP value
 

Try this Kent
http://vbnet.mvps.org/code/reg/regaccounts.htm

I never used it myself


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Kent" wrote in message ...
I will use Ron de Bruin excellent code to send Excelsheets by mail with CDO.
The excel-sheet is used by different users with different SMTP server values,
so I cannot put a fixed value into the code.
Does anybody know the code to return the current SMTP value, so I can give
this value to a variable ?

Regards
Kent