{"id":979,"date":"2012-01-07T18:30:06","date_gmt":"2012-01-07T13:00:06","guid":{"rendered":"http:\/\/www.automationrepository.com\/?p=979"},"modified":"2012-01-07T18:34:47","modified_gmt":"2012-01-07T13:04:47","slug":"automating-outlook-using-qtp-working-with-outlook-folders","status":"publish","type":"post","link":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/","title":{"rendered":"Part 3: Automating Outlook using QTP | Working with Outlook Folders"},"content":{"rendered":"
\n

Till now, we have covered the basics of automating MS Outlook<\/a> as well as overview of Outlook Object Model<\/a>. In this article, you’ll see how you can access the Outlook folders and work with them. You would see how to find specific folder by name, how to create a new folder in outlook, how to delete an existing folder and how to move\/copy folders to a given destination.<\/p>\n

To access Outlook folders, you would need to use the MAPIFolder<\/strong> class which contains the methods and properties needed to access, create and customize folders. MAPIFolder provides 16 default objects using which you can access different Outlook folders such as e-mail messages, tasks, contact items etc<\/strong>. Let us some examples on how you can access outlook folders and work with them.
\n
\n<\/span>
\nSample Code 1: Display total number of folders and name of each folder inside Inbox Folder.<\/strong> Let’s see the code that displays the number and names of folders inside Inbox folder. The figure below the code snippet shows the snapshot of Outlook Inbox folder and the output value.<\/p>\n

\r\nDim iCount, sFolderNames\r\nsFolderNames = ""\r\n\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Inbox Folder\r\nSet oInbox = objNamespace.GetDefaultFolder(6)\r\n'Find list of all folders within Inbox Folder\r\nSet oAllFolders = oInbox.Folders\r\niCount = oAllFolders.Count\r\nsFolderNames = "Total Folders = " & iCount & vbcrlf & vbcrlf\r\n\r\n'Get the names of the folders\r\nFor i = 1 to iCount\r\n\tsFolderNames = sFolderNames & "Folder " & i & " -> " & oAllFolders(i).Name & vbcrlf\r\nNext\r\n'Display folder count and folder names in msgbox\r\nmsgbox sFolderNames\r\n<\/pre>\n
\"Working
Working with Outlook Folders<\/p><\/div>\n

\n<\/span>
\nSample Code 2: Add and Delete folders in Outlook.<\/strong> In this example, we’ll add a new folder (named Folder1) and delete an already existing folder (Test3) from Outlook Inbox.<\/p>\n
\r\nDim addFolderName, delFolderName\r\naddFolderName = "Folder1"\r\ndelFolderName = "Test3"\r\n\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Inbox Folder\r\nSet oInbox = objNamespace.GetDefaultFolder(6)\r\n\r\n'Add new folder in Outlook Inbox\r\noInbox.Folders.Add addFolderName\r\n\r\n'Find list of all folders within Inbox\r\nSet oAllFolders = oInbox.Folders\r\niCount = oAllFolders.Count\r\n\r\n'Delete folder from Outlook Inbox\r\nFor i = 1 to iCount\r\n If oAllFolders(i).Name = delFolderName Then\r\n  oAllFolders(i).Delete\r\n  Exit For\r\n End If\r\nNext\r\n<\/pre>\n
\"Add
Add & Delete Folders from Outlook<\/p><\/div>\n

\n<\/span>
\nSample Code 3: Copy and Move folders from one location to another.<\/strong> In this example, we’ll copy and move folders from Inbox to Junk Folder<\/p>\n
\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Inbox & JunkMail Folders\r\nSet oInbox = objNamespace.GetDefaultFolder(6)\r\nSet oJunk = objNamespace.GetDefaultFolder(23)\r\n\r\n'Find list of all folders within Inbox\r\nSet oAllFolders = oInbox.Folders\r\niCount = oAllFolders.Count\r\n\r\n'Delete folder from Outlook Inbox\r\nFor i = 1 to iCount\r\n    If oAllFolders(i).Name = "Copy Folder" Then\r\n      'Copy folder from Inbox to Junk Folder\r\n      oAllFolders(i).CopyTo(oJunk)\r\n    ElseIf oAllFolders(i).Name = "Move Folder" Then\r\n      'Move folder from Inbox to Junk Folder\r\n      oAllFolders(i).MoveTo(oJunk)\r\n    End If\r\nNext\r\n<\/pre>\n
\"Copy
Copy and Move Folders in Outlook<\/p><\/div>\n

\n<\/span>
\nIn all the above examples, we have worked mostly with the Inbox folder (which was represented by integer value 6). If you want to work with any other folder in Outlook (such as Drafts, Sent Items, etc), all you need to do is use the enumeration value associated with that particular folder. For your reference, we have listed down all the 16 default outlook folder types with their enumerations.<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\n\n
Value
\n<\/strong><\/p>\n<\/td>\n
Description<\/strong><\/td>\n<\/tr>\n
olFolderCalendar<\/td>\n9<\/td>\nThe Calendar folder.<\/td>\n<\/tr>\n
olFolderConflicts<\/td>\n19<\/td>\nThe Conflicts folder (subfolder of Sync Issues folder). Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderContacts<\/td>\n10<\/td>\nThe Contacts folder.<\/td>\n<\/tr>\n
olFolderDeletedItems<\/td>\n3<\/td>\nThe Deleted Items folder.<\/td>\n<\/tr>\n
olFolderDrafts<\/td>\n16<\/td>\nThe Drafts folder.<\/td>\n<\/tr>\n
olFolderInbox<\/td>\n6<\/td>\nThe Inbox folder.<\/td>\n<\/tr>\n
olFolderJournal<\/td>\n11<\/td>\nThe Journal folder.<\/td>\n<\/tr>\n
olFolderJunk<\/td>\n23<\/td>\nThe Junk E-Mail folder.<\/td>\n<\/tr>\n
olFolderLocalFailures<\/td>\n21<\/td>\nThe Local Failures folder (subfolder of Sync Issues folder). Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderManagedEmail<\/td>\n29<\/td>\nThe top-level folder in the Managed Folders group. For more information on Managed Folders, see Help in Microsoft Outlook. Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderNotes<\/td>\n12<\/td>\nThe Notes folder.<\/td>\n<\/tr>\n
olFolderOutbox<\/td>\n4<\/td>\nThe Outbox folder.<\/td>\n<\/tr>\n
olFolderSentMail<\/td>\n5<\/td>\nThe Sent Mail folder.<\/td>\n<\/tr>\n
olFolderServerFailures<\/td>\n22<\/td>\nThe Server Failures folder (subfolder of Sync Issues folder). Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderSyncIssues<\/td>\n20<\/td>\nThe Sync Issues folder. Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderTasks<\/td>\n13<\/td>\nThe Tasks folder.<\/td>\n<\/tr>\n
olFolderToDo<\/td>\n28<\/td>\nThe To Do folder.<\/td>\n<\/tr>\n
olPublicFoldersAllPublicFolders<\/td>\n18<\/td>\nThe All Public Folders folder in the Exchange Public Folders store. Only available for an Exchange account.<\/td>\n<\/tr>\n
olFolderRssFeeds<\/td>\n25<\/td>\nThe RSS Feeds folder.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n<\/span><\/p>\n
If you feel that we have missed out any important concept, or if you want any other topic to be covered here, please leave a comment or just drop in a mail to us. We’ll be more than happy to work on it.<\/p>\n
\n
If you enjoyed this article, you can join our blog to get new posts delivered directly in your inbox.<\/p>\n
   <\/p>\n
\n<\/form>\n<\/div>\n

\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Till now, we have covered the basics of automating MS Outlook as well as overview of Outlook Object Model. In this article, you’ll see how you can access the Outlook folders and work with them. You would see how to find specific folder by name, how to create a new folder in outlook, how to<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,9],"tags":[54],"class_list":["post-979","post","type-post","status-publish","format-standard","hentry","category-advanced-concepts","category-qtp-concepts","tag-automating-outlook-using-qtp"],"yoast_head":"\nPart 3: Automating Outlook | Working with Outlook Folders<\/title>\n<meta name=\"description\" content=\"You would see how to find specific folder by name, how to create a new folder in outlook, how to delete an existing folder and how to move\/copy folders to a given destination.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Anish Pillai\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/\",\"name\":\"Part 3: Automating Outlook | Working with Outlook Folders\",\"isPartOf\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png\",\"datePublished\":\"2012-01-07T13:00:06+00:00\",\"dateModified\":\"2012-01-07T13:04:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20\"},\"description\":\"You would see how to find specific folder by name, how to create a new folder in outlook, how to delete an existing folder and how to move\/copy folders to a given destination.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png\",\"contentUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.automationrepository.com\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Part 3: Automating Outlook using QTP | Working with Outlook Folders\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#website\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/\",\"name\":\"XX\",\"description\":\"\\r\\nasas\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.automationrepository.com\/wordpress\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20\",\"name\":\"Anish Pillai\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8aa984de2295c3c4078fa48f6ba5d91e7c849b1a27a11dca24c6f11dd673ba14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8aa984de2295c3c4078fa48f6ba5d91e7c849b1a27a11dca24c6f11dd673ba14?s=96&d=mm&r=g\",\"caption\":\"Anish Pillai\"},\"description\":\"Find more about Anish Pillai on Google+\",\"sameAs\":[\"http:\/\/www.automationrepository.com\"],\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/author\/anish\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Part 3: Automating Outlook | Working with Outlook Folders","description":"You would see how to find specific folder by name, how to create a new folder in outlook, how to delete an existing folder and how to move\/copy folders to a given destination.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/","twitter_misc":{"Written by":"Anish Pillai","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/","url":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/","name":"Part 3: Automating Outlook | Working with Outlook Folders","isPartOf":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage"},"image":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage"},"thumbnailUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png","datePublished":"2012-01-07T13:00:06+00:00","dateModified":"2012-01-07T13:04:47+00:00","author":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20"},"description":"You would see how to find specific folder by name, how to create a new folder in outlook, how to delete an existing folder and how to move\/copy folders to a given destination.","breadcrumb":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#primaryimage","url":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png","contentUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-inbox-folder.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-folders\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.automationrepository.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Part 3: Automating Outlook using QTP | Working with Outlook Folders"}]},{"@type":"WebSite","@id":"https:\/\/www.automationrepository.com\/wordpress\/#website","url":"https:\/\/www.automationrepository.com\/wordpress\/","name":"XX","description":"\r\nasas","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.automationrepository.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20","name":"Anish Pillai","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8aa984de2295c3c4078fa48f6ba5d91e7c849b1a27a11dca24c6f11dd673ba14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8aa984de2295c3c4078fa48f6ba5d91e7c849b1a27a11dca24c6f11dd673ba14?s=96&d=mm&r=g","caption":"Anish Pillai"},"description":"Find more about Anish Pillai on Google+","sameAs":["http:\/\/www.automationrepository.com"],"url":"https:\/\/www.automationrepository.com\/wordpress\/author\/anish\/"}]}},"_links":{"self":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/comments?post=979"}],"version-history":[{"count":9,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/979\/revisions"}],"predecessor-version":[{"id":987,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/979\/revisions\/987"}],"wp:attachment":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/media?parent=979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/categories?post=979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/tags?post=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}