+ Reply to Thread
Results 1 to 4 of 4

Send Email Loop with increasing number till maximum increment reached then reset and End

  1. #1
    Registered User
    Join Date
    01-21-2018
    Location
    Northampton, England
    MS-Off Ver
    2010
    Posts
    57

    Send Email Loop with increasing number till maximum increment reached then reset and End

    Hi all,

    I am trying to create an additional Sub that uses the below send email code that already works in the document
    Im looking for it to complete a loop increasing the number each time within the designated cell then send the email again untill the number in the cell reaches the maximum number placed in a seperate cell.
    An example of this would be the number increasing by one each time till it reaches the maximum of 61 before sending the last email and reseting the number to 1.

    This will send an email with each increase so the events would be as follows,

    Button Click >
    Check Ready Status (If ["Don't Send"={Increase Cell Value & Check again}] ["Report Ready"={Send Email}) >
    Increase Cell Value >
    Check if over Maximum number (If Over value in L20=[Message: Sending Complete], Under or Equal to value in L20=[Loop to Check Ready Status])

    Information Cells,
    Cell for Increasing each time - L15
    Cell with maximum number in - L20
    Cell With Ready Status, "Don't Send" "Report Ready" - L10

    Please Login or Register  to view this content.
    Thanks in Advance

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    862

    Re: Send Email Loop with increasing number till maximum increment reached then reset and E

    Seems you need something like this: (somewhat tested)

    Please Login or Register  to view this content.
    Last edited by cubangt; 07-12-2021 at 05:15 PM.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  3. #3
    Registered User
    Join Date
    01-21-2018
    Location
    Northampton, England
    MS-Off Ver
    2010
    Posts
    57

    Re: Send Email Loop with increasing number till maximum increment reached then reset and E

    Quote Originally Posted by cubangt View Post
    Seems you need something like this: (somewhat tested)

    Please Login or Register  to view this content.
    How would this fit into the initial send email code? Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    862

    Re: Send Email Loop with increasing number till maximum increment reached then reset and E

    I'm making a change, can you explain the "status" logic a bit more

    I see the following, but not sure when the changes to the status need to happen.

    #1 Don't Send = THIS IS THE DEFAULT STARTING MESSAGE?
    #2 Report Ready = WHAT CONDITION NEEDS TO BE MET TO SET IT TO THIS?
    #3 Sending Complete = IS THIS NEEDED, IF THE VALUE IS RESET ONCE THE LAST EMAIL IS SENT, IT WILL NEVER GET OVER THE MAX NUMBER.

    Im only guessing, but im thinking that when the count is reset back to 1, that the message is reset to "Don't Send" not "Sending Complete", maybe im wrong..


    Button Click >
    Check Ready Status (If ["Don't Send"={Increase Cell Value & Check again}] ["Report Ready"={Send Email}) >
    Increase Cell Value >
    Check if over Maximum number (If Over value in L20=[Message: Sending Complete], Under or Equal to value in L20=[Loop to Check Ready Status])

    Information Cells,
    Cell for Increasing each time - L15
    Cell with maximum number in - L20
    Cell With Ready Status, "Don't Send" "Report Ready" - L10

+ 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. Increment by 1 if email is send else no increment.
    By A9kurs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2021, 01:25 PM
  2. [SOLVED] Count upward then once certain number reached reset back to 0
    By aleross in forum Excel General
    Replies: 15
    Last Post: 09-20-2019, 11:27 AM
  3. [SOLVED] Excel VBA to Auto Send Email When a Date is Reached
    By SingularUK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2018, 02:47 PM
  4. send an email automatically when the due date is reached even when excel is closed
    By isurunk1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2017, 10:13 PM
  5. How to send Automated Email when specific cell value reached due date
    By grlinks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2016, 12:22 AM
  6. Set outlook to send email when due date is reached
    By Camps1 in forum Excel General
    Replies: 5
    Last Post: 10-09-2014, 06:38 AM
  7. setting an set number of 41 and having it reset to 0 once 41 is reached
    By the_spc_four82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2011, 03:50 PM

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