Hi, please can anyone help.

I've been using the fantastic code from Ron De Bruin at
http://www.rondebruin.nl/sendmail.htm, and have also got around the 5
second XP/Outlook 2003 security feature by using other code found at
www.excelforum.com...


..Display

Application.Wait (Now + TimeValue("0:00:01"))
Application.SendKeys "%S"

Rather than simply.....

..Send

Rather than sending mails in the background this displays each mail and
pauses for 1 second before sending it. It works just fine as long as
the spell-checker is turned off.

I'm not sure it's the code that is the problem, but maybe a setting
somewhere. It works (with slight adjustments) in Office 2000 and on my
old XP/Office 2003 machine.

However, I've just moved to a different role - apparently with the same
apps....XP and Office 2003, but instead of sending the mails it's just
opening each one and leaving it on screen.

I have things like the MS Outlook 11 library turned on etc, and have
tried adjusting some of the setting options in Outlook, but I just
can't get the thing to work!!

Does anyone have any ideas on how I might resolve this please?

AND - thanks you so much for all of the amazing and valuable knowledge
that you've shared in the past. I'm learning a lot, and I could not
have done it without you.......I just don't know the answer to this
problem - yet!

Wherever you are, I hope you're having a great day.

Chris


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.excelforum.com/member.php...fo&userid=1350
View this thread: http://www.excelforum.com/showthread...hreadid=504892