Excel VBA Introduction Part 29.12 – Filtering Outlook Items using Restrict




About this tutorial:

Video duration: 24:17
By Andrew Gould

– This video explains how to filter the items in the Outlook inbox using the restrict method. You’ll learn about the basic syntax of Jet filters in Outlook and how to apply them to filter a list of emails using a variety of properties such as the importance, size, sender name and received date.

If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos, you can click this link to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

8 thoughts on “Excel VBA Introduction Part 29.12 – Filtering Outlook Items using Restrict

    Sam

    (June 12, 2019 - 12:23 pm)

    Awesome video as usual Andy

    Lautaro Barrera

    (June 12, 2019 - 12:23 pm)

    One question: this method assume that all folders content will support the filter? I ran this and when processing the folder “contacts’ an error was thrown as within this folder the property SenderName is unknown.
    Andrew, I also wanted to take this opportunity to thank you. Your videos are just excellent !!

    Andrés Roldán

    (June 12, 2019 - 12:23 pm)

    Andrew I am a follower, your job is just outstandingly good!
    As feedback: Today I was thinking that it would attract more viewers if you showed the code working at the beginning of the video before teaching how to build it.

    Ravi Singhal

    (June 12, 2019 - 12:23 pm)

    I learnt all my vba skill by just watching your videos…. Your are awesome nd a great teacher….. Thanks for all stuff you given..can you provide class on putting GIF in userform and adjusting its properties.

    Antriksh Sharma

    (June 12, 2019 - 12:23 pm)

    Hey Andy, awesome video as always do you think you could create a video on Outlook VBA as well? where one could write code in the Outlook and let's say if certain email comes then some details pertaining to that email gets saved on an Excel sheet and keeps updating.

    Urs Venky

    (June 12, 2019 - 12:23 pm)

    Hey, this useful but my macro is stopping me at when appointment mails are available in inbox. How to filter appointment mails (include or exclude). It'll helpful to ur followers

    krn14242

    (June 12, 2019 - 12:23 pm)

    Thanks Andrew. Interesting information. My [SenderName] had to be Last, First. I guess differences in the Exchange server.. 🙂

    RAVI MARNENI

    (June 12, 2019 - 12:23 pm)

    First comment, 2nd time in a row. Thank you for amazing videos Andrew.

Leave a Reply

Your email address will not be published. Required fields are marked *