![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n \n
Hey, Scripting Guy! I read your article on filtering email messages<\/B><\/A> in Microsoft Outlook, and it\u2019s almost<\/I> what I need, but not quite. What I really need to know is this: how can I filter Outlook messages by the email address of the person who sent the message? Hey, SJS. Say, you weren\u2019t by any chance at the Columbia Athletic Club this past weekend, were you? We didn\u2019t think so, but we thought we should ask. On Saturday the Scripting Guy who writes this column and the Scripting Son went to the gym to play basketball. As they stepped inside some stranger began glaring at the Scripting Guy who writes this column, as if to say, \u201cListen, buddy, there\u2019s no way that both of us are leaving this gym alive.\u201d At first the Scripting Guy who writes this column didn\u2019t pay much attention; having never seen this guy before, he assumed the man must be glaring at someone else. But then the Scripting Son spoke up:<\/P>\n \u201cSo Dad: are you gonna fight that guy over there?\u201d<\/P>\n \u201cWell, it kind of looks that way, doesn\u2019t it?\u201d<\/P>\n In fact, the man in question glared at the Scripting Guy who writes this column as he and the Scripting Son checked in, and continued glaring as the two walked through the exercise room and headed for the basketball court. <\/P>\n Yes, very<\/I> strange. Not that the Scripting Guy who writes this column isn\u2019t used to people glaring at him with looks of utter hatred and disgust; he gets that at work pretty much every day. But it was<\/I> a bit unusual for someone to glare at him at the gym. At the gym people are much more likely to giggle<\/I> when he walks by. <\/P>\n And then burst out laughing when he tries doing the bench press.<\/P>\n At any rate, the Scripting Guy who writes this column spent the weekend wondering why a total stranger would glare at him like that. At first he couldn\u2019t come up with any reason. And then he thought, \u201cHmmm, maybe that guy wanted to know how to do something like, say, filter Outlook email messages by email address. Maybe he wrote to Hey, Scripting Guy!<\/I> and we haven\u2019t answered him yet. Maybe we should answer his question and see if that<\/I> makes him happy.\u201d<\/P>\n If you were<\/I> the angry guy at the gym, SJS, we hope this helps, and we apologize for taking so long to get around to your question. And if you weren\u2019t<\/I> the angry guy at the gym, well, do us a favor, OK: if you happen to run into the crazy guy, please don\u2019t tell him that we answered your question instead of his?<\/P>\n Here\u2019s how you (or the angry guy, for that matter) can filter Outlook email messages by email address:<\/P> Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderInbox)<\/p>\n Set colItems = objFolder.Items\nSet colFilteredItems = colItems.Restrict(“[SenderEmailAddress] = ‘kenmyer@fabrikam.com'”)<\/p>\n For Each objMessage In colFilteredItems\n Wscript.Echo objMessage.Subject\nNext\n<\/PRE>\n Whoa, don\u2019t look at us like that; we were just about to explain how the script works. (Really.) We start out by defining a constant named olFolderInbox and setting the value to 6; that tells the script which Outlook folder (in this case the Inbox folder) we want to work with. Next we create an instance of the Outlook.Application<\/B> object and bind to the MAPI<\/I> namespace. We then use this line of code and the GetDefaultFolder<\/B> method to make a connection to the Inbox folder:<\/P> Now for the good stuff. The first thing we do is use this line of code to return a collection of all the items (that is, all the email messages) found in the Inbox folder:<\/P> And you\u2019re right: we don\u2019t<\/I> want all the items in the Inbox, do we? Instead, we want only those emails that were sent by kenmyer@fabrikam.com<\/I>. That\u2019s what this line of code is for:<\/P> All we\u2019re doing here just grabbing a subset of the items found in the Inbox. To do that we call the Restrict<\/B> method, passing the method two parameters:<\/P>\n [SenderEmailAddress]<\/B>, the property we want to filter on. Note that the property name must be enclosed in square brackets.<\/P><\/TD><\/TR>\n kenmyer@fabrikam.com<\/B>, the criteria to be applied to the filter. In this case, we want the get back only emails where the SenderEmailAddress is equal to kenmyer@fabrikam.com<\/I>.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n Ah, that\u2019s a good question: can<\/I> we include multiple criteria in a filter? You bet we can. For example, here\u2019s a filter that returns emails sent by kenmyer@fabrikam.com or<\/I> by packerman@contoso.com:<\/P> One thing to keep in mind here is the fact that, because we are dealing with email addresses, Outlook security might kick in when we run this script. That means that a dialog box might pop up telling us that someone (or something) is trying to access email addresses; in turn, we\u2019ll have to use that dialog box to explicitly grant the script access to the data. For more information, see our original article<\/B><\/A> on filtering email messages.<\/P>\n
— SJS<\/P>![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/A> \nConst olFolderInbox = 6<\/p>\n
Set objFolder = objNamespace.GetDefaultFolder(olFolderInbox)\n<\/PRE>\n
Set colItems = objFolder.Items\n<\/PRE>\n
Set colFilteredItems = colItems.Restrict(“[SenderEmailAddress] = ‘kenmyer@fabrikam.com'”)\n<\/PRE>\n
\n\n
\n \u2022<\/TD>\n \n \n \u2022<\/TD>\n \n Set colFilteredItems = colItems.Restrict _\n (“[SenderEmailAddress] = ‘kenmyer@fabrikam.com’ OR [SenderEmailAddress] = ‘packerman@contoso.com'”)\n<\/PRE>\n