Sending mail from Excel with CDO - return SMTP value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending mail from Excel with CDO by Ron de Bruin 4
CDO, SMTP Server Name, and Excel's SendMail Method 4
Excel CDO 5
Sending mail CDO from Excel 2007 on Vista 5
Sending e-mail using CDO 1
CDO mailing from Excel 6
How 2 remove this error - SMTP Server, Email using CDO 1
Formatting issue when sending e-mail via CDO to Excel 2007 1

Back
Top