Delayed mass email sending

Status
Not open for further replies.
P

Phil Lynch

Member
Outlook version
Email Account
POP3
Hi!

I have just accepted a new position at a financial services firm. I need to send an email to 50 prospects everyday. My Outlook will be checked by my boss to make sure it's done (because I work from home). Instead of sending these emails one by one, I was wondering if it was possible to use a macro that would send them one at a time, with a random delay between each. Then, I could do something else instead!

My database is an Excel spreadsheet.

Thanks!

Phil Lynch
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Cheaters never prosper. :)




You can do one of two things - mail merge or a utility. I'm not aware of any macro code available to do this, probably because its complicated, but it would be possible to write one as there are addins that do it. Unless you have VBA skills, an addin will be more cost effective (and give you more time to do something else :)).




If the messages will be identical, save for personal info (name, address) you can use mail merge. Addins that delay sending (intended for isp's that throttle outgoing traffic but should also work for you) are here: http://www.slipstick.com/addins/mail-tools/mass-mail-tools-for-outlook/ - most have free trials. A few sound like they might meet your needs perfectly and offer a bit more customization than Outlook's basic mail merge.




Even without mail merge, there are ways to speed up the sending process so it could take less than a minute per message - but i would probably use mail merge instead. Using software to be more productive is not cheating - it's using technology as it was intended.
 
P

Phil Lynch

Member
Outlook version
Email Account
POP3
Wow! That was fast!

I just tried one addin that does exactly what I need! For 40$, it's a steal!

Thanks SO much Diane.

Phil Lynch
 
Status
Not open for further replies.
< User defined field not found in any views prints. Cannot locate to delete. | Programmatically accessing Outlook Calendar data >
Similar threads
Thread starter Title Forum Replies Date
M Subject Line Automation - Trigger Script Delayed Outlook VBA and Custom Forms 2
mikolajek Outlook 2013 IMAP actions (message move / delete etc.) significantly delayed Using Outlook 0
D 2 Week Delayed Message Using Outlook 7
S Email get delayed when sent!!! Using Outlook 1
G Mass Updating Contact form used Outlook VBA and Custom Forms 8
M adding corresponding contact form data on a mass scale Using Outlook 5
J Add-in for sending mass emails Using Outlook 14
B Mass customized emails sent weekly Using Outlook 0
David French Mass e-mail avoiding SPAM Using Outlook 1
SirFishAlot Send atachment with mass email using BCM, and Publisher 2013 BCM (Business Contact Manager) 1
W Mass emailing to contacts linked to accounts BCM (Business Contact Manager) 1
J Mass find & delete email addresses from address book. Using Outlook 3
A How to send Personalized attachment while sending mass mail Using Outlook 1
D Sending mass e-mail (picture only) Using Outlook 1
J Mass Printing to a 'Category' BCM (Business Contact Manager) 1
A Need help in creating a mass emailing plugin Outlook VBA and Custom Forms 1
M "File As" option lost company name- Mass change? Outlook VBA and Custom Forms 5
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
A Search folder and move the email Outlook VBA and Custom Forms 0
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
D Delete selected text in outgoing email body Outlook VBA and Custom Forms 0
F Graphics in email / Mac recipient garbled Using Outlook 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
G Print email attachments when hit subfolder Outlook VBA and Custom Forms 1
C Spam Email? Using Outlook 2
G Automatically delete email when a condition is met Outlook VBA and Custom Forms 1
E Save Selected Email Message as .msg File - digitally sign email doesn't works Outlook VBA and Custom Forms 1
S Email was migrated from GoDaddy to Microsoft exchange. We lost IMAP ability Exchange Server Administration 1
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
S Paperclip icon shows without attachment in email under Sent folder Using Outlook 0
B Outlook 2019 Automatically move email after assigning category Using Outlook 4
Rupert Dragwater How to permanently remove an email address Using Outlook 9
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
F Want to add second email to Outlook for business use Using Outlook 4
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
A Outlook 2019 Help with forwarding email without mentioning the previous email sender. Outlook VBA and Custom Forms 0
J Macro to send email as alias Outlook VBA and Custom Forms 0
M Shift Delete doesn't delete email from server Using Outlook 3
K Incorporate selection from combobox into body of email Outlook VBA and Custom Forms 0
L Why are some email automatically going to "archive" Using Outlook 2
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0

Similar threads

Top