![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n \n
Hey, Scripting Guy! How can I get a list of all the senders\u2019 email addresses in an Outlook folder? Hey, CW. You know, you must get email from a whole different set of people than we Scripting Guys do. For example, in looking through the Scripting Guys Inboxes it appears as though all our mail comes from the following sources:<\/P>\n
— CW<\/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> \n
| \u2022<\/TD>\n | \n Service representatives pointing out that our bank\/eBay\/PayPal account is about to expire, and noting that we need to log on to a specified Web site in order to prevent any interruption in service.<\/P><\/TD><\/TR>\n | |
| \u2022<\/TD>\n | \n Evangelist Frank Radebe, the first son of the late Dr. John Radebe; Mr. Greg Stevenson, staff of Kleinwort Benson; Rev. Jones De; and Ms. Angela Dikko Emile, the daughter of Professor Emile Boga Doudou, all of whom need our help transferring money from an African bank to a U.S. bank. (But not as a favor to them, mind you; they\u2019re more than willing to pay us for our trouble.)<\/P><\/TD><\/TR>\n | |
| \u2022<\/TD>\n | \n Pharmaceutical salespeople who might be sampling their wares more than doctors recommend: \u201cTts h’erbal solution what hasnt no side effect, but has 100% guaranted resultss.\u201d<\/P><\/TD><\/TR>\n | |
| \u2022<\/TD>\n | \n Beautiful, sexy girls who got our names from a mutual friend and are just dying<\/I> to meet the male Scripting Guys.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n Note<\/B>. OK, those last ones could be legitimate.<\/P>\n Well, they could<\/I> be.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n In other words, we Scripting Guys don\u2019t have much need to get a list of all the people who send us<\/I> email. (OK, that h\u2019erbal solution might come in handy, but other than that \u2026) Like we said, though, you might hang around with a different crowd than we do. If that\u2019s the case, then a script like this one might be just the thing you need:<\/P> Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderInbox)<\/p>\n Set colItems = objFolder.Items<\/p>\n For Each objItem in colItems\n Wscript.Echo objItem.SenderEmailAddress\nNext\n<\/PRE>\n Yes, it is<\/I> a nice little script, isn\u2019t it? (We\u2019re guessing that\u2019s why Angela Dikko Emile came to us for help; she probably figured that if we could write a script like that then transferring money from an African bank to a U.S. bank would be a snap.) As you can see, we start out simply enough, defining a constant named olFolderInbox and setting the value to 6; in a minute or two we\u2019ll use that constant to tell the script which Outlook folder we want to work with.<\/P>\n After defining the constant we create an instance of the Outlook.Application<\/B> object, then use the GetNamespace<\/B> method to bind to the MAPI namespace. (That\u2019s actually the only<\/I> namespace we can bind to, but we still have to bind to it. Kind of like having to fill out an income tax return even though they\u2019ve already taken all your money.) After that we use the GetDefaultFolder<\/B> method to bind us to the Inbox folder:<\/P> See: we told<\/I> you we\u2019d use the constant olFolderInbox to help us connect to the Inbox, didn\u2019t we?<\/P>\n After connecting to the Inbox folder we can then use this line of code to retrieve a collection of all the items (i.e., all the email messages) found in that folder:<\/P> At this point all we have to do is set up a For Each loop and loop through the collection of email messages; for each message in that collection we simply echo back the value of the SenderEmailAddress<\/B> property. Keep in mind, however, that when you try to access the SenderEmailAddress the following Outlook security dialog box is going to pop up onscreen:<\/P> And that\u2019s it: in a matter of seconds the sender email addresses for all the items in your Inbox will be displayed onscreen.<\/P>\n Like we said, this script retrieves information from your Inbox folders. What if you\u2019d like to pull the list of email addresses from a subfolder<\/I> of the Inbox? To tell you the truth, we weren\u2019t sure if we could do that at first. However, after just one application of the miracle h\u2019erbal solution (\u201c100% guaranted resultss!\u201d) we came up with this:<\/P> Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderInbox)<\/p>\n Set objSubfolder = objFolder.Folders(“Test”)<\/p>\n Set colItems = objSubFolder.Items<\/p>\n For Each objItem in colItems\n Wscript.Echo objItem.SenderEmailAddress\nNext\n<\/PRE>\n In this script we bind to \u2013 and retrieve email addresses from \u2013 a subfolder of the Inbox, a subfolder named Test. How do we do that? Well, after binding to the Inbox we use this line of code to connect us to the Test subfolder:<\/P> All we have to do then is make sure we retrieve the collection of emails from this subfolder:<\/P> Good question: that works if the folder is a subfolder on the Inbox. But what if the folder we\u2019re interested in is on the same level as the Inbox? How the heck do we access a folder like that<\/I>? Well, we\u2019ll tell you, but you\u2019ll have to wait until tomorrow\u2019s column.<\/P>\n |
![\"Outlook\"](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/office\/tips\/outlookbox.jpg\")
\n