View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kent kent is offline
external usenet poster
 
Posts: 37
Default 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