Delaying transmission of messages

  • Thread starter Thread starter John K. King
  • Start date Start date
J

John K. King

Hi:

Ok, Partial success. I've been able to delay sending the
messages using the DeferredDeliveryDate. To delay it by 10
minutes I used:

objOutlookMsg.DeferredDeliveryDate = DateAdd("n", 10, Now
())

and, after one test, it appears to work fine. However, the
problem is that the message still leaves the Outbox and
goes to the Exchange Server prior to sending. That denies
me the opportunity to inspect, and if necessary or
desireable, edit or delete prior to sending.

So, I'm still looking for ideas.

Thanks,
JK
 
If you are using SQL Server you can send the emails using the SMTP
server built-in to Windows 2000 and not send the emails via Exchange
and Outlook. You could put the pending emails in a table and use that
for inspecting them, then send from the table via the SMTP server when
you want to.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 
Hi Ken:
-----Original Message-----
If you are using SQL Server you can send the emails using the SMTP
server built-in to Windows 2000 and not send the emails via Exchange
and Outlook. You could put the pending emails in a table and use that
for inspecting them, then send from the table via the SMTP server when
you want to.
Click to expand...

I've considered that, and I may go that way, but for some
reason I'm not as comfortable with that as I'd like. Plus,
it does add a bit more work.

I may be going about this all wrong, actually. I had a
thought a few minutes ago that perhaps what I really want
to do is, rather than send the message, I should store it
in the 'Drafts' folder. That actually maps to the real
world model more neatly.

Now I just have to figure out how to do that. I need to
dig into some books, but if you have any suggestions, I'll
be happy to hear them.

Again, thanks for your time. I do appreciate it.

JK
 
You could always cancel the Send event. Closing the item after saving
it would automatically put the new mail item in Drafts but you
shouldn't use close in the send event, it can cause crashes.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 
Back
Top