+ Reply to Thread
Results 1 to 4 of 4

Looping through the sent items of not older than 3 weeks

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,706

    Looping through the sent items of not older than 3 weeks

    Hi,

    I am using the bellow code to loop through the sent items in outlook.

    Please Login or Register  to view this content.
    The code is working fine but I want it to narrow down the loop for items that are not older than 3 weeks.

    The only other way I am thinking (if there is no solution) to first move required number of items to a temp folder and then loop. is it possible to narrow down right inside the folder ?
    Teach me Excel VBA

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,904

    Re: Looping through the sent items of not older than 3 weeks

    Not tested:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,641

    Re: Looping through the sent items of not older than 3 weeks

    In the future please post in the correct forum.
    I moved it this time

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,706

    Re: Looping through the sent items of not older than 3 weeks

    Thanks Pepe Le Mokko, I will post in the proper forum. But as you honored this thread in this forum.I would like to get it solved in the same forum

    Thanks for the review and solution but we are still looping all items.

    Let me be more clear
    for example if I want to get all cells in a column in excel that are not blank, I would narrow down my loop as bellow

    Please Login or Register  to view this content.
    means I have excluded the irrelevant cells before loop and then looped the ones which should have been of my work.

    Likewise I would like a way to exclude the irrelevant Outlook items and then loop the ones that I needed

    Hope this makes sense.

    Best Regards
    Imran Bhatti

+ 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: 1
    Last Post: 10-20-2016, 04:11 AM
  2. [SOLVED] Looping through dictionary items where items are an array
    By strud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2014, 06:56 AM
  3. Moving 30 days and older messages from "Sent Items" to "Deleted Items"
    By bandera in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2014, 07:09 AM
  4. Looping by weeks...by months
    By tmd2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2011, 10:45 PM
  5. [SOLVED] Number of Items open longer than 1 week but less than 2 weeks
    By Andibevan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10: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