PDA

View Full Version : [SOLVED] Excel Sending email



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

lucas
07-20-2006, 09:01 AM
Here is a previous discussion on bypassing the Outlook warning messages:
http://vbaexpress.com/forum/showthread.php?t=7847&highlight=security

lostin_space
07-25-2006, 08:39 AM
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 :friends: