lostin_space
07-20-2006, 03:40 AM
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
:banghead: :dunno
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
:banghead: :dunno