+ Reply to Thread
Results 1 to 6 of 6

Schedule Email Sending through Outlook using Excel Data

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Schedule Email Sending through Outlook using Excel Data

    Hello,

    I have an Excel sheet with 20,000 email addresses. I want to send each email-address the same short message via Outlook... but need to stagger each send so the emails go out every few minutes.

    I have 5 columns: A email address, B subject line, C message, D schedule day, E schedule time. (see attachment for example sheet).email schedule outlook.xls. I'd like Outlook to send based on each email addresses scheduled time slot.

    I've searched the web and cannot find a way... I'm not sure if it went over my head reading over like-scenarios/solutions, or if it's just not possible (but I feel all things are possible through Excel!)

    Please help if you know how -- or let me down if you know it's not possible. Thanks!

    --J18

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Schedule Email Sending through Outlook using Excel Data

    What about this? This sends all the emails to Outlook on a delayed delivery.

    You'll need to set the Outlook reference.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 01-13-2015 at 04:51 PM.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Schedule Email Sending through Outlook using Excel Data

    Sorry, I'm (inconveniently) randomly versed in some of these terms... so...

    YES! Sending on a delayed delivery is perfect. Thank you!!!

    As for setting the Outlook reference -- What does this mean? Is this something I need to do in Outlook or Excel? We'll only be using Excel & Outlook... no other mail clients.

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Schedule Email Sending through Outlook using Excel Data

    From the Sheet. Alt F11, Tools -> References -> scroll down until you see Microsoft Outlook 14.0 Object Library. Be sure to check the box to the left -> OK.

    Insert -> Module -> Paste code in.
    Last edited by Tinbendr; 01-13-2015 at 04:52 PM.

  5. #5
    Registered User
    Join Date
    05-01-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Schedule Email Sending through Outlook using Excel Data

    Yes it worked!!!! Thanks!

    One last question (and major rep points regardless!) -- is it possible to do this and add an attachment (like PDF)?

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Schedule Email Sending through Outlook using Excel Data

    You can pass it to the sub routine like the others, or you can just add it directly.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 01-14-2015 at 04:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help with sending email from Excel via Web Outlook (OWA)
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2014, 05:23 PM
  2. [SOLVED] sending email from outlook using vba excel
    By joshshaji in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-31-2012, 08:27 PM
  3. sending email with Outlook using Excel
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2006, 02:45 PM
  4. [SOLVED] sending & retrieving excel data in body of outlook email
    By mismarple in forum Excel General
    Replies: 2
    Last Post: 09-22-2005, 11:05 AM
  5. [SOLVED] Schedule sending an email on a particular day picked from excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1