Find outlook emails that match ID numbers in Excel

**mtwa1990** · 01-09-2021, 04:44 AM

Hi everyone,

I have a list of ID numbers in excel and when we have sent an email it gets marked with the sent date and when we get the reply we mark it again. Due to user error some get missed so I've to get excel to search through outlook Sent box to see if an email had been sent.
I now need to do this for the Inbox however there are many subfolders that the email could be hiding in and i only know how to search the main inbox, could anybody help me in getting it to also go through every subfolder?

Also is there a way to make this quicker as it did take 3 days to complete!!! I came across maybe using "items.Restrict" not sure if that would work for what i need it for and if it would be quicker - https://docs.microsoft.com/en-us/off...items.restrict I did try however i couldn't understand/get it to work.

The below code goes through outlook Sent box to find the emails that have been sent to change it to inbox i would change "olFolderSentMail" to "olFolderInbox" but that only looks in the inbox not sub folders.

Please Login or Register  to view this content.

Any help would be greatly appreciated especially if it makes the process quicker seeing as i was hoping to complete it by Monday

Thank you for your help
Martin

**vba_php** · 01-09-2021, 08:01 AM

if you look at the dependency links, one nest after the other, in the MS URL you posted:

https://docs.microsoft.com/en-us/off...items.restrict

https://docs.microsoft.com/en-us/off.../outlook.items

https://docs.microsoft.com/en-us/off...k-item-objects

you eventually read this in the last link:

The following are the item-level objects defined in the Outlook object model:
.......
.......
.......

and nowhere on that page do you read *anything* about folders. Thus, you can't use it, more than likely. the only thing close is this:

Please Login or Register  to view this content.

but you are not looking for content inside an email message itself. you want to search messages inside a folder. So, if you're not aware, the protocol called MAPI is widely used in email clients, outlook specifically. if you look here:

https://www.google.com/search?q=vba+...ubfolders+mapi

you'll find your answer, more than likely. there was also someone here recently that was doing the same thing and did it mostly themselves. they already had the MAPI being used in their own code. check it out:

https://www.excelforum.com/outlook-f...ime-error.html

and my help starts here:

https://www.excelforum.com/outlook-f...ml#post5442273

MAPI is what is called a namespace. that word is very popular, but in outlook the concept is severely outdated. it means something totally different now to corporate professionals.

Find outlook emails that match ID numbers in Excel

LinkBack

Thread Tools

Rate This Thread

Display

Find outlook emails that match ID numbers in Excel

Re: Find outlook emails that match ID numbers in Excel

Thread Information

Users Browsing this Thread

Similar Threads

Outlook vba macro to monitor new emails is not firing when new emails are received. Help?

[SOLVED] Macro to Draft Outlook Emails and Attach files in Emails

[SOLVED] Excel VBA Outlook needing to add to and CC to outlook emails

Track Outlook Emails - sent emails in Excel

[SOLVED] Sending Outlook emails from Excel; Limits to three emails only?

Excel VBA to find keywords in outlook and then move those emails based on the keyword

Send outlook emails with message in cells to individual emails associated with them

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions