View Single Post
  #6  
Old September 28th 06, 03:44 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default "Do you want to allow this" messages driving me mad! Tried Clickyes and Redemption

Did you look at that entry in the Redemption FAQ?

Here is the later part of that FAQ entry, it has the answer you're looking
for:

There is however one problem if you are using Outlook 2002 with a PST file
and POP3/SMTP transport provider or Outlook 2000 installed in the Internet
Only Mode: there is no way to flush the queues using Extended MAPI. That
part of Outlook is simply broken. Note however that Outlook 2002/2003
(online) with an Exchange Server or Outlook 2000 C/W in any configuration
are fine.

If you are using Outlook 2003 with Exchange in a cached mode, it will
exhibit the same problem. Uncheck "Use cached mode" in the Exchange Server
properties to force online mode - that will ensure that messages are
delivered immediately.

Microsoft is aware of the problem, and they are working on providing a
workaround. As a last resort, you can simulate clicking "Send/Receive"
button in Outlook after sending a message:



MailItem.Send

Set Btn = Application.ActiveExplorer.CommandBars.FindControl (1, 5488)

Btn.Execute



Note that in Outlook 2003 that button is now a dropdown, the real
Send/Receive is a subitem of the button:

Set Btn = Application.ActiveExplorer.CommandBars.FindControl (1, 7095)
Btn.Execute

Note that the code above assumes that there is an active Explorer; this will
not be the case if you start Outlook programmatically (and it was not
previously started by a user) and do not display any folders. In this case
you can start a sync using the the Namespace.SyncObjects collection.

set NS = Application.GetNamespace("MAPI")
NS.Logon
Set Sync = NS.SyncObjects.Item(1)
Sync.Start


--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Biguana" wrote in message
ups.com...
OK. I've now sorted the carriage returns, it was in HTML previously.
Thanks.

But the main problem is that they will not send!!! I've tried saving
them previously, and again since you mentioned it, but it makes no
difference.

In the drafts folder (when italicised) they have a "sent date" and time
from when the code ran, but if I open and close them that disappears,
and they are no longer italicised.

I wouldn't mind manually clicking send and receive, but manually
opening and sending 200 emails is not reasonable. Can anyone help?

Tim


Ads