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
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 3
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 4
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
T Problem when requesting to view an email in a browser Using Outlook 0
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
HarvMan Archive Email Manually Using Outlook 1
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
S New Email "From" box stopped working Using Outlook 0
Rupert Dragwater Duplicate email in Folder Using Outlook 8
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
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
MattC Changing the font of an email with VBA Outlook VBA and Custom Forms 0
L Specific Incoming Email Address Immediately Deleted Using Outlook 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3
V Macro to mark email with a Category Outlook VBA and Custom Forms 4
R Roadrunner Email Settings | Contact Roadrunner Customer Support Outlook VBA and Custom Forms 1
D Gmail mail is being delivered to a different email inbox in Outlook App 2021 Using Outlook 2
Albert McCann Outlook 2021 Outlook Display of HTML Email from two senders is glitchy Using Outlook 0
A How Do I Setup My Optonline.Net Email Account? Outlook VBA and Custom Forms 1
H Preventing the 'email address fetch from Exchange' crashing email reading code Exchange Server Administration 0
D multiple email accounts - why do I have to choose the "from" account address?? Using Outlook 2

Similar threads

Top