Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Problems sending mail from Excel to Outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Big Chris - 25 Jan 2006 13:36 GMT
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

Signature

Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!

Ron de Bruin - 25 Jan 2006 14:08 GMT
Hi Big Chris

SendKeys is not always reliable

See
http://www.rondebruin.nl/mail/prevent.htm

CDO is the best way if you can use it

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Hi, please can anyone help.
>
[quoted text clipped - 38 lines]
>
> Chris
Tom Ogilvy - 25 Jan 2006 14:09 GMT
have you looked at the CDO approach Ron has on his site to get around the
security features.

Signature

Regards,
Tom Ogilvy

> Hi, please can anyone help.
>
[quoted text clipped - 38 lines]
>
> Chris
Big Chris - 25 Jan 2006 16:44 GMT
Thanks Tom and Ron for your quick response, as we say in certain parts
of the UK, you're 'Diamond Geezers'.

I really thought I'd got the security thing sorted with SendKeys, but
it seems not. I can't load ClickYes as it's locked down PC and the
company are not too helpful in helping me to do my own comms thang (5
seconds per message takes abit long with 1,000 mails anyway).

My Outlook has fallen over just 24 hours into the new role, so I can't
even test anything yet - it'll take me some hours to work it all out
anyway.

In the meantime, thanks again for your superb support.

Regards,

Chris

----------------------------------------------------

Signature

Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.