Excel Sending email

[lostin_space]

Hi,
Is there any way in excel, using VBa you can find, and then contain in a variable, the name of a users' Exchange server?

i'm trying to write a script that will send an email from excel, without triggering the Outlook 2k3 warning messages.

I'm using Ron De Bruen's solution of CDO (see http://www.rondebruin.nl/cdo.htm) within excel.

the trouble with this solution i am finding is, you need to be speficic about the exchange server to be used in the script. Unfortunately, we've got over 100+ exchange servers within my organisation!

Any help - greatfully received

Regards

[lucas]

Here is a previous discussion on bypassing the Outlook warning messages:
http://vbaexpress.com/forum/showthre...light=security

[lostin_space]

i gave up in the end - the nag screen will keep the users awake. i've rolled out the app now - they're happy with it!

cheers for your help