+ Reply to Thread
Results 1 to 2 of 2

Loop through emails to find Email today, if not found loop Date -1

  1. #1
    Forum Contributor
    Join Date
    09-23-2015
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    187

    Cool Loop through emails to find Email today, if not found loop Date -1

    Hello,

    I have the following code that will Loop and search for an email sent by a sender, with a specific subject, sent today, saves and opens that attachment. I am trying to edit the loop, that if it does not find the email specified above (sender and subject, date today) then to look at date -1 , yesterday and loop until it finds. How can I edit the code below to do that?Many thanks for your help

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Loop through emails to find Email today, if not found loop Date -1

    Not tested...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. Replies: 0
    Last Post: 04-25-2019, 08:54 AM
  2. VBA to loop through range to find date closest to today's date
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2017, 02:08 AM
  3. [SOLVED] Auto email loop with formatted table data breaking on second loop VBA
    By Who_else in forum Excel General
    Replies: 6
    Last Post: 03-24-2016, 06:22 AM
  4. Replies: 4
    Last Post: 04-03-2014, 12:19 AM
  5. loop to find integers and decimals and pass found row to bookmark code.
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 08:00 AM
  6. Loop through Column to find decimal then pass found row to bookmark code
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 11:13 AM
  7. Copy, Paste loop based on today's Date
    By oscarmiike in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-22-2014, 09:05 PM

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