Outbox throttler

Status
Not open for further replies.

mr_malkovich

Senior Member
Outlook version
Email Account
Exchange Server
Have to preface this by apologizing for all the posts. I'm just in the process of expanding our database dramatically and... it's a lot. I appreciate all your advice over the years more than you know. BTW, is there a way to donate to the site? Would be worth every penny.

I know about the delay delivery function. What I'm looking for is a way to have outlook send, say, 100 emails in 100 minutes, as opposed to as fast as the connection can spit them out. Is that possible?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
it is possible - there are addins that do it and i have a macro - my macro adds time to the current time, so it wouldn't be exactly 1 per minute but with the right formula, it could be.
This would be 1 minute from now:
SendinOne = Now + TimeSerial(0, 1, 0)
after the first message to set to that time, add a minute to it:
SendinOne =SendinOne + TimeSerial(0, 1, 0)



macro is here: Set a default 'Do not Deliver before' time (the method can be used in any macro that creates the messages)
Utilities are here: Mass Mail Tools for Outlook
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
There is probably a shorter line you could use*** by this will get you now + 1 min:
SendAt = DateSerial(Year(Now), Month(Now), Day(Now)) + TimeSerial(Hour(Now), Minute(Now) + 1, 0)

So you set that early in the macro then loop to increment it -
newsend = DateSerial(Year(SendAt), Month(SendAt), Day(SendAt)) + TimeSerial(Hour(SendAt), Minute(SendAt) + 1, 0)
SendAt = newsend

pretty much any vba that works with time in excel (and probably access) will likely work as long as you get it into standard format: 5/5/2017 1:18:00 PM

oh, and the macro assumes you are using send immediately. :)

*** if you are sending "today", Date + TimeSerial(Hour(Now), Minute(Now) + 1, 0) is shorter.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
it could be an itemsend macro in thisoutlooksession or if using a macro to create the messages, the necessary code could be added to it.

i thought the speery and mapilabs utilities added the delays. others may as well.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J E-mail held in Outbox while Minimized Using Outlook 3
L Need help modifying a VBA script for emails stuck in Outbox Outlook VBA and Custom Forms 6
B Emails get stuck in Outbox of Gmail IMAP in Outlook for Windows Using Outlook 0
GregS Outlook 2016 Can I disable the Outlook Outbox? Using Outlook 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
U Outbox Message Stuck after reading some MailItem Properties with VBA Outlook VBA and Custom Forms 1
A Cant See outbox items on a secondary Account Exchange Server Administration 3
T SMTP messages stuck in Outbox Using Outlook 0
I Outlook 2013 Send mail - it just sticks in Outbox Using Outlook.com accounts in Outlook 0
P Outlook 2013 puts replies in Outbox Using Outlook 1
Diane Poremsky After viewing the Outbox, messages won't send Using Outlook 0
D Close Oulook after sending emails via vba without outbox getting stuck. Outlook VBA and Custom Forms 1
M Messages in Outbox reminder is wrong Using Outlook 4
D Use single outbox in Outlook 2013 Using Outlook 1
T Two Outbox's in 2007 but neither send Using Outlook 8
iwshim Transfering mail from the outbox to another computer Using Outlook 0
G "Delay Delivery" Email fails to send if opened while in Outbox Using Outlook 4
F Outbox - Multiple Emails need to be manually opened? Using Outlook 5
B OUTBOX ERROR!!!!! Using Outlook 20
James Emails Stuck In Outlook Outbox Happening Alot Using Outlook 1
Loperman Emails hang in Outbox Using Outlook 1
C Outlook 2013 - Email Gets Sent - But Does Not Move From Outbox to Sent Box Using Outlook 4
M some emails send from outbox, some don't Using Outlook 10
S Mystery emails in Outbox Using Outlook 1
J Change Subject of 500 mails sitting in Outbox with Macro Using Outlook 6
B Cannot send emails-stuck in OutBox: OUTLOOK 2013 Using Outlook 4
E lost contacts on emptying outbox? Using Outlook 5
N Stuck in Outlook 10 Outbox Using Outlook 0
M Messages Held in Outbox 2007 Outlook 2010 Using Outlook 1
K blank emails generated in outbox when clicking on Inbox and other foders Using Outlook 0
R Force use of general outbox Using Outlook 1
J Emails stuck in Outlook outbox Using Outlook 11
P OL 2007 XP email stuck in outbox Using Outlook 3
D Email stuck in Outbox Using Outlook 3
X Exchange 2013 - Emails stuck in Outbox folder Exchange Server Administration 3
D Emails stuck in Outbox, not receiving emails, Outlook 2010 auto send/receive Using Outlook 4
D Outbox will not send, error code 0X800CCC78 with 550 sender restricted. Using Outlook 3
G Email stuck in Outbox - Office 2013 Using Outlook 5
N Email Stuck in Outbox - Cached Mode - Roaming Profile Using Outlook 2
D Windows 7 / Outlook 2007 - email gets stuck in Outbox Using Outlook 2
A Mail Merge - Sent but still in Outbox Using Outlook 5
T Sent emails remain in Outbox Using Outlook 3
P Messages stuck in outbox and must be sent again. Using Outlook 1
C Fix for Outlook Outbox Error Message Using Outlook 1
J Outlook 2010 messages freeze in outbox, do not autosave, then disappear after Outlook locks up Using Outlook 7
S Send All emails in Outbox and Quit using VBA Outlook VBA and Custom Forms 3
R Outbox not responding Outlook VBA and Custom Forms 7
C RE: unable to delete large message clogging outbox Using Outlook 3

Similar threads

Top