+ Reply to Thread
Results 1 to 3 of 3

Automating mail send in batches, with a delay between each batch

  1. #1
    Registered User
    Join Date
    10-09-2021
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    2

    Automating mail send in batches, with a delay between each batch

    I need to send about 10.000 emails in batches of 1 to 99 bcc recipients each, and with a 6-8 minute delay between each batch. To do so I've attempted a doevents-based strategy. While doevents seems to free the resources, mail.send is not being performed. The mails just build up in the outbox, without being sent (I have even included a separate "Until mail.Sent" loop of doevents).

    How can I free the resources for send?


    Please Login or Register  to view this content.
    Last edited by Torledo; 10-10-2021 at 09:39 AM.

  2. #2
    Registered User
    Join Date
    10-09-2021
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    2

    Re: Automating mail send in batches, with a delay between each batch

    DeferredDeliveryTime did the job.

    Please Login or Register  to view this content.
    Last edited by Torledo; 10-10-2021 at 06:09 PM.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Automating mail send in batches, with a delay between each batch

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. VBA to execute formula in batches (or with delay)
    By dechesne in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2016, 07:59 AM
  2. Replies: 0
    Last Post: 05-14-2015, 07:04 PM
  3. Replies: 1
    Last Post: 03-11-2014, 12:24 PM
  4. Macro to send emails in batches.
    By dilipsunder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2013, 03:25 PM
  5. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 AM
  6. [SOLVED] Automating Access / Excel with batch file
    By Art in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2005, 07:05 PM
  7. Replies: 9
    Last Post: 05-29-2005, 02:05 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