Delayed mass email sending

Status
Not open for further replies.

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

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.
 

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.
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
J Outlook 2019 Regex email addresses from body Outlook VBA and Custom Forms 2
D Prompt to prefix subject line whenever sending an email Outlook VBA and Custom Forms 3
J Quick steps delete original email and move reply/sent email to folder Using Outlook 2
C Wishlist Extract or scan new email addresses from out of office replies. Leads from OOO replies Using Outlook 1
T External email warning banner Outlook VBA and Custom Forms 0
A Links in email getting error message about group policy Using Outlook 4
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
Geldner Tweak Junk Email Reporting tool to default to particular email on send? Using Outlook 3
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
V Can one change the formatting of email title blocks? Using Outlook 0
P default font when sending email from browser Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
B IMAP server rejects sent email - cannot deliver messages Using Outlook 2
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
X Open Hyperlinks in an Outlook Email Message (Help with Diane's solution) Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Email notifications changed with Outlook 2021 Using Outlook 8
glnz How to retrieve or redo Verizon.net email password without affecting Outlook connection? Using Outlook 1
Z Copy specific email body text Outlook VBA and Custom Forms 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
M Outlook 365 refuses to send email Using Outlook 1
B Search and Find Email by Folder Name Outlook VBA and Custom Forms 2
K Closing external IMAP email... Outlook 2013 Using Outlook 0
L Capture email addresses and create a comma separated list Outlook VBA and Custom Forms 5
C Email bomb processing Outlook VBA and Custom Forms 1
O What would be the recommended way to change an email address (family member)? Using Outlook 0
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
J How do you disable address search box when typing @ in body of email? Using Outlook 0
S HTML Code Embedded in String Within Open Outlook Email Preventing Replace(Application.ActiveInspector.CurrentItem.HTMLBody From Working Outlook VBA and Custom Forms 4
Victor.Ayala Automated way to check the option "Show this folder as an email Address Book" Outlook VBA and Custom Forms 2
D Wrong email address in Outlook 2003 "From" tab in new outgoing emails Using Outlook 4
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1

Similar threads

Top