I have an Excel VBA macro that sends mail using CDO. Works fine, but
users have to enter their SMTP Server in a designated cell.

Most of the users are using Outlook. Can I get the SMTP Server name
from Outlook by automating Outlook?


Thanks,

Greg