Delay Send and Mail Merge

Status
Not open for further replies.
K

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.
 
Diane Poremsky said:
See Delay Delivery of Messages Sent at Specific Times - you'll probably want to remove the lines that check the time of day... :)
Click to expand...

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​
 
Diane Poremsky said:
See Delay Delivery of Messages Sent at Specific Times - you'll probably want to remove the lines that check the time of day... :)
Click to expand...

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?
kavihasya said:
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​
Click to expand...
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.
< VBA Macro - Run-time error '424': object required - Help Please | VBA Macro for assigning multiple Categories to an email in my Inbox >
Similar threads
Thread starter Title Forum Replies Date
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
D Delay Send not working Using Outlook 3
G "Delay Delivery" Email fails to send if opened while in Outbox Using Outlook 4
T Exchange Server - Mail Delay Stamping Exchange Server Administration 0
L Modifying VBA script to delay running macro Outlook VBA and Custom Forms 3
J Diane's Delay Delivery at Specific Times Questions Outlook VBA and Custom Forms 7
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 Using Outlook 0
Diane Poremsky To delay sending a message in Outlook Using Outlook 0
B Macro to delay email Outlook VBA and Custom Forms 0
Diane Poremsky To delay sending a message in Outlook Using Outlook 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
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
P Removing Outlook 365 Account from Send/Receive Using Outlook 3
J Outlook macro to run before email is being send Outlook VBA and Custom Forms 3
J Saving Send emails to a folder on the server Outlook VBA and Custom Forms 63
J Outlook 2019 Pick the Folder Location to save send emails Outlook VBA and Custom Forms 0
D Send email from Outlook Alias using Mac? Using Outlook 0
E FUNCTION SEND/RECEIVE OUTLLOK AND VB6 Outlook VBA and Custom Forms 3
R How to use VB .Net to send emails? Outlook VBA and Custom Forms 0
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 4
C Synchronization and taking forever to send Using Outlook 2
D Send on behalf of does not store the base mailbox Using Outlook 0
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 2
J Macro to send email as alias Outlook VBA and Custom Forms 0
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
W Outlook 365 I am getting the "Either there is no default mail client" error when I try to send an email on excel Office 365 Using Outlook 1
T Outlook 2010 recipient no longer shows in 'Send To' Using Outlook 0
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
L How to avoid issues with "Send on Behalf" Using Outlook 3
M Outlook 365 refuses to send email Using Outlook 0
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
M I cant send emails via Outlook in my W10 PC. Using Outlook 3
K Run a script rule to auto 'send again' on undeliverable emails? Outlook VBA and Custom Forms 1
G Send a greeting message to a contact on birthday Outlook VBA and Custom Forms 5
T Outlook creates a copie of every mail I send Using Outlook.com accounts in Outlook 4
R How to restrict GWSMO sync to Outlook Send/Receive cycles Using Outlook 0
M Outlook, send to > mail recipient - results in plain text email Using Outlook 1
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 0
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

Similar threads

Back
Top