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
|