{"id":66193,"date":"2006-10-24T12:49:00","date_gmt":"2006-10-24T12:49:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/10\/24\/how-can-i-connect-to-the-junk-mail-folder-in-outlook\/"},"modified":"2006-10-24T12:49:00","modified_gmt":"2006-10-24T12:49:00","slug":"how-can-i-connect-to-the-junk-mail-folder-in-outlook","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-connect-to-the-junk-mail-folder-in-outlook\/","title":{"rendered":"How Can I Connect to the Junk Mail Folder in Outlook?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! Over the past year or so you\u2019ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?

— ME<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, ME. Let\u2019s see, what time is<\/I> it? OK good: we have enough time to answer this question and get the column posted. We were a little worried about that, because the Scripting Guy who writes this column has been running late all day today. But that\u2019s not entirely his fault; for example, after taking a shower this morning he was drying himself off when his eye caught this notice on the bath towel label:<\/P>\n

Not suitable for wearing apparel.<\/B><\/P>\n

A bath towel, by itself, is not suitable for wearing apparel?!? Why didn\u2019t someone tell him that earlier<\/I>? As you might expect, that forced him to rethink his wardrobe for the day, and got him off to a bad start before the day ever really got started.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Although, admittedly, rethinking his wardrobe isn\u2019t really that big of a deal; most days that simply involves picking between the black hooded-sweatshirt and the grey hooded-sweatshirt. Today he went with grey. Tomorrow? Who knows?<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

Fortunately, the Scripting Guy who writes this column was able to make it to work on time, and \u2013 for once \u2013 showed up suitably attired. In turn, that gave him enough time to come up with a simple little demonstration script that connects to the Junk Mail folder in Outlook and reports back the number of items in that folder:<\/P>

Const olFolderJunk = 23<\/p>\n
Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderJunk)<\/p>\n
Set colItems = objFolder.Items\nWscript.Echo colItems.Count\n<\/PRE>\n
Pretty simple, isn\u2019t it? Not only that, but the key to this script comes in the very first line, the line where we define a constant named olFolderJunk and set the value to 23:<\/P>
Const olFolderJunk = 23\n<\/PRE>\n
As you know, Outlook contains a number of predefined folders, including the Inbox, the Calendar, the Contacts folder, and, of course, the Junk Mail folder. Connecting to one of these folders \u2013 as we\u2019re about to see \u2013 is as simple as passing the appropriate value to the GetDefaultFolder<\/B> method. For example, to bind to the Junk Mail folder you need to pass the value 23 (either directly, or by using a constant) to GetDefaultFolder.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Is it just a coincidence that 23 is also the number of flavors blended together to make Dr. Pepper? Unfortunately, we can\u2019t help you there; that\u2019s the sort of thing everyone will have to decide for themselves.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
After we define the constant olFolderJunk we create an instance of the Outlook.Application<\/B> object and then use the GetNamespace<\/B> method to bind to the MAPI<\/B> namespace. (Which, interestingly enough, is the only<\/I> namespace we can bind to.) We then use this line of code to create an object reference to the Junk Mail folder:<\/P>
Set objFolder = objNamespace.GetDefaultFolder(olFolderJunk)\n<\/PRE>\n
That\u2019s basically the whole script right there. In the last two lines of code we retrieve a collection of all the items in the Junk Mail folder and then echo back the value of the Count<\/B> property; that simply tells us how many junk emails are currently in the folder. Obviously that\u2019s not required; we added that code simply so the script would do something besides bind to the folder. Alternatively, we could have used a script like this one to go ahead and delete all the items in the folder:<\/P>
Const olFolderJunk = 23<\/p>\n
Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderJunk)<\/p>\n
Set colItems = objFolder.Items<\/p>\n
For Each objItem in colItems\n    objItem.Delete\nNext\n<\/PRE>\n
Cool, huh?<\/P>\n
In case you\u2019re wondering here are the constants (and their corresponding values) for the other default folders built into Microsoft Outlook:<\/P>\n\n<\/THEAD>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
Constant<\/B><\/P><\/TD>\n
\n
Value<\/B><\/P><\/TD><\/TR>\n
\n
olFolderCalendar<\/P><\/TD>\n
\n
9<\/P><\/TD><\/TR>\n
\n
olFolderContacts<\/P><\/TD>\n
\n
10<\/P><\/TD><\/TR>\n
\n
olFolderDeletedItems<\/P><\/TD>\n
\n
3<\/P><\/TD><\/TR>\n
\n
olFolderDrafts<\/P><\/TD>\n
\n
16<\/P><\/TD><\/TR>\n
\n
olFolderInbox<\/P><\/TD>\n
\n
6<\/P><\/TD><\/TR>\n
\n
olFolderJournal<\/P><\/TD>\n
\n
11<\/P><\/TD><\/TR>\n
\n
olFolderJunk<\/P><\/TD>\n
\n
23<\/P><\/TD><\/TR>\n
\n
olFolderNotes<\/P><\/TD>\n
\n
12<\/P><\/TD><\/TR>\n
\n
olFolderOutbox<\/P><\/TD>\n
\n
4<\/P><\/TD><\/TR>\n
\n
olFolderSentMail<\/P><\/TD>\n
\n
5<\/P><\/TD><\/TR>\n
\n
olFolderTasks<\/P><\/TD>\n
\n
13<\/P><\/TD><\/TR>\n
\n
olPublicFoldersAllPublicFolders<\/P><\/TD>\n
\n
18<\/P><\/TD><\/TR>\n
\n
olFolderConflicts<\/P><\/TD>\n
\n
19<\/P><\/TD><\/TR>\n
\n
olFolderLocalFailures<\/P><\/TD>\n
\n
21<\/P><\/TD><\/TR>\n
\n
olFolderServerFailures<\/P><\/TD>\n
\n
22<\/P><\/TD><\/TR>\n
\n
olFolderSyncIssues<\/P><\/TD>\n
\n
20<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
So what are we supposed to do<\/I> with all this information? Well, according to the table, the Drafts folder has a value of 16. That means a simple little script like this will tell you how many items are in the Drafts folder:<\/P>
Const olFolderDrafts = 16<\/p>\n
Set objOutlook = CreateObject(“Outlook.Application”)\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)\nSet objFolder = objNamespace.GetDefaultFolder(olFolderDrafts)<\/p>\n
Set colItems = objFolder.Items\nWscript.Echo colItems.Count\n<\/PRE>\n
Etc., etc.<\/P>\n
By the way, we have a confession to make: the Scripting Guy who writes this column didn\u2019t really<\/I> consider wearing a towel to work today. After all, thanks to the last such \u2026 incident \u2026 one of his fellow Scripting Guys always calls every morning to remind him that a towel is not suitable for wearing apparel. He learned his lesson, the hard way.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! Over the past year or so you\u2019ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?— ME Hey, ME. Let\u2019s see, what time is it? OK good: we have enough time to […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[212,49,3,5],"class_list":["post-66193","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-outlook","tag-office","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! Over the past year or so you\u2019ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?— ME Hey, ME. Let\u2019s see, what time is it? OK good: we have enough time to […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/66193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=66193"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/66193\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=66193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=66193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=66193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}