Delay Send and Mail Merge

Status
Not open for further replies.

kavihasya

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Looking for a macro that will solve all my problems.

I support a program that runs numerous events, at the end of which an email needs to be sent inviting the recipient to fill out a survey. I obviously don't want to send these emails out before the event has taken place. I would prefer to schedule the sending of these emails in advance to better manage my workflow

I create these emails through a mail merge (sending the messages into my offline email outbox). But it seems that the only way to delay sending by more than 120 minutes is to go into each email individually and change it - Not a great solution!

Is there a macro out there that will allow me to select more than one email, and specify a specific date and time to send those emails? Most of the stuff I've found online has to do with waiting til the next morning - I sometimes want to wait more than a week to send stuff out.
 

kavihasya

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
See Delay Delivery of Messages Sent at Specific Times - you'll probably want to remove the lines that check the time of day... :)

Uh, most of it is checking the time of day?

Is this what you are thinking of?

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
SendDate = InputBox("Enter date to send")
SendAt = SendDate + #7:00:00 PM#
Item.DeferredDeliveryTime = SendAt
End Sub​
 

kavihasya

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
See Delay Delivery of Messages Sent at Specific Times - you'll probably want to remove the lines that check the time of day... :)

Oh, but I'm also noticing that this will impact everything that I send! How do I get it to only impact selected messages in my outbox?
Uh, most of it is checking the time of day?

Is this what you are thinking of?

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
SendDate = InputBox("Enter date to send")
SendAt = SendDate + #7:00:00 PM#
Item.DeferredDeliveryTime = SendAt
End Sub​
Oh, but I'm also noticing that this will impact everything. I only want this to apply to specific messages I select. Not everything. How do I specify?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Delay / Send outgoing mail during certain hours Using Outlook 1
D Delay Send not working Using Outlook 3
G "Delay Delivery" Email fails to send if opened while in Outbox Using Outlook 4
H Messages won't leave Outbox - sit in Date:None and cannot be sent (delay send becomes checked as wel Using Outlook 1
J Diane's Delay Delivery at Specific Times Questions Outlook VBA and Custom Forms 5
T Query About "Delay Delivery" Function Using Outlook 5
X Delay sending an email until the next working day (public holidays) Outlook VBA and Custom Forms 0
S Delay Delivery Macro Outlook VBA and Custom Forms 1
Diane Poremsky Delay Delivery of Messages Sent at Specific Times New Slipstick.com Articles 0
Diane Poremsky To delay sending a message in Outlook New Slipstick.com Articles 0
B Macro to delay email Outlook VBA and Custom Forms 0
Diane Poremsky To delay sending a message in Outlook New Slipstick.com Articles 1
D Delay Delivery: Visible to recipients? Using Outlook 1
Y All emails are received with delay on outlook 2010 Using Outlook 5
M How to forward a message and delay sending for up to 30 days Using Outlook 8
R Long delay for outgoing mail Using Outlook 2
P time delay between accessing Outlook file folders, up 20+ second delay Using Outlook 1
W Attachment delay issue for listing network files Using Outlook 1
I Long delay in switching folders since I installed IE 9 Beta Using Outlook 2
S 6 to 8 second delay in folders opening since installing a number of updates yesterday. Using Outlook 1
K Outlook 2007 Delay Delivery feature not working Using Outlook 1
N Outlook 2007 and 2010 New Mail Delay Exchange Server Administration 1
P Delay delivery not working in Outlook Using Outlook 1
J Delay sending emails in Office Outlook 2010 Using Outlook 2
A E-mail receive delay in Exchange 2010 Exchange Server Administration 4
K Delay after creating a room before Set-CalendarProcessing functions Exchange Server Administration 8
J Rule to Forward email but delay delivery 10 minutes Outlook VBA and Custom Forms 2
C Outlook 2007 Delay Delivery Problem Using Outlook 10
A Unflag Inbox and Flag Inbox with Orange Category After Item is send Outlook VBA and Custom Forms 3
glnz O365 - How to send from acct 2 but showing email name from acct 1 as From - alias? Using Outlook 1
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
PGSystemTester VBA To Change AppointmentItem.BusyStatus From MeetingItem Before Send Using Outlook 0
C Synchronizing subscribed folders causes hanging during send/receive process Using Outlook 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
T After I send a new email, it remains in the Draft folder Using Outlook.com accounts in Outlook 3
B Programmatically force html send and insert clipboard contents into body Outlook VBA and Custom Forms 0
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
M ERROR: None of your email accounts could send to this recipient Using Outlook 2
C Send/receive error 80040119 Using Outlook 2
J Send Again NDR Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
ChrisK2 Send email to advertise@slipstick.com fails: "The group advertising isn't set up to receive messages from..." Using Outlook 3
B resend if no reply and send an automatic reminder Outlook VBA and Custom Forms 0
F Send As a Gmail account via outlook Web Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
X Unable to send an email from one account to another on same PC Using Outlook 2
S Meeting Invite arrives from Wrong ("send-as") Sender Using Outlook 1

Similar threads

Top