Thread: Sending mail from Excel with CDO - return SMTP value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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


Reply With QuoteReply With Quote