Solved: Getting the users exchange server name

[lostin_space]

Hi,
Is there any way in VBa you find out, 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

[Bob Phillips]

See the code sample for that at
http://www.cdolive.com/cdo5.htm#HomeServerOfCurrentUser

[lostin_space]

perfect! many thanks!