{"id":990,"date":"2012-01-08T21:20:31","date_gmt":"2012-01-08T15:50:31","guid":{"rendered":"http:\/\/www.automationrepository.com\/?p=990"},"modified":"2012-01-08T21:21:46","modified_gmt":"2012-01-08T15:51:46","slug":"automating-outlook-using-qtp-working-with-outlook-contacts","status":"publish","type":"post","link":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/","title":{"rendered":"Part 4: Automating Outlook using QTP | Working with Outlook Contacts"},"content":{"rendered":"
\n

In this article, you’ll see how you can work with Outlook Contacts. We’ll cover various topics such as how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.<\/p>\n

In Outlook, Contact Items are stored in Contacts folder and it is represented by ContactItem object.<\/strong> ContactItem objects contain a variety of contact information, such as people’s street addresses, e-mail addresses, and phone numbers. It also provides a set of methods using which you can access Outlook Contacts. Let’s see few examples on how to work with Outlook Contacts.
\n
\n<\/span>
\n Sample Code 1: Access Outlook Contacts and display details of a Contact.<\/strong> Here the script accesses contact items from Contacts folder and displays the details of the first contact.<\/p>\n

\r\nDim sMessage\r\nsMessage = ""\r\n\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Contacts Folder\r\nSet oContacts = objNamespace.GetDefaultFolder(10)\r\n\r\n'Find all items in the Contacts Folder\r\nSet oAllContacts = oContacts.Items\r\niCount = oAllContacts.Count\r\nsMessage = "Total Contacts -> " & iCount & vbCrLf & vbCrLf\r\n\r\n'Find out different properties of the first contact\r\nIf iCount >= 1 Then\r\n\tsMessage = sMessage & "Full Name - " & oAllContacts(1).FullName & vbCrLf\r\n\tsMessage = sMessage & "Company - " & oAllContacts(1).CompanyName & vbCrLf\r\n\tsMessage = sMessage & "Job Title - " & oAllContacts(1).JobTitle & vbCrLf\r\n\tsMessage = sMessage & "File As - " & oAllContacts(1).FileAs & vbCrLf\r\n\tsMessage = sMessage & "Email - " & oAllContacts(1).Email1Address & vbCrLf\r\n\tsMessage = sMessage & "Display As - " & oAllContacts(1).Email1DisplayName & vbCrLf\r\n\tsMessage = sMessage & "Web Page - " & oAllContacts(1).WebPage & vbCrLf\r\nEnd If\r\n'Display the contact properties\r\nmsgbox sMessage\r\n<\/pre>\n
\"Access
Access Outlook Contact Details<\/p><\/div>\n

\n<\/span>
\nSample Code 2: Create a new Outlook Contact.<\/strong> This example creates a new Outlook Contact and displays it.<\/p>\n
\r\nDim olContactItem\r\n'olContactItem is Referenced by Value 2\r\nolContactItem = 2\r\n\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet oNewContact = objOutlook.CreateItem(2)\r\n\r\n'Set Properties for the new Contact\r\noNewContact.FirstName = "First"\r\noNewContact.LastName = "Last"\r\noNewContact.Email1Address = "first@email.com"\r\noNewContact.CustomerID = "123456"\r\noNewContact.PrimaryTelephoneNumber = "(91)0000000000"\r\noNewContact.MailingAddressStreet = "Street"\r\noNewContact.MailingAddressCity = "City"\r\noNewContact.MailingAddressState = "State"\r\n\r\n'Save details and display\r\noNewContact.Save\r\noNewContact.Display\r\n<\/pre>\n
\"Create
Create New Outlook Contact<\/p><\/div>\n

\n<\/span>
\nSample Code 3: Copy an Existing Outlook Contact.<\/strong> This example searches for a contact with a specific mail id and then creates a copy of the same.<\/p>\n
\r\nDim iCount, objReturnVal\r\n\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Contacts Folder\r\nSet oContacts = objNamespace.GetDefaultFolder(10)\r\n\r\n'Find all items in the Contacts Folder\r\nSet oAllContacts = oContacts.Items\r\niCount = oAllContacts.Count\r\n\r\n'Copy an existing contact\r\nFor i=1 to iCount\r\n  If oAllContacts(i).Email1Address = "abc@email.com" Then\r\n    'objReturnVal is the object that contains the copied Contact\r\n    Set objReturnVal = \toAllContacts(i).Copy\r\n    Exit For\r\n  End If\r\nNext\r\n\r\n'Display Results\r\nmsgbox "Contact Copied. Full Name -> " & objReturnVal.FullName\r\n<\/pre>\n

\n<\/span>
\nSample Code 4: Delete an Outlook Contact.<\/strong> This example deletes an Outlook Contact based on a specific criteria<\/p>\n
\r\nSet objOutlook = CreateObject("Outlook.Application")\r\nSet objNamespace = objOutlook.GetNamespace("MAPI")\r\n\r\n'Create reference to Contacts Folder\r\nSet oContacts = objNamespace.GetDefaultFolder(10)\r\n\r\n'Find all items in the Contacts Folder\r\nSet oAllContacts = oContacts.Items\r\niCount = oAllContacts.Count\r\n\r\nFor i = 1 to iCount\r\n  If oAllContacts(i).Email1Address = "abc@email.com" Then\r\n    oAllContacts(i).Delete\r\n    Exit For\r\n  End If\r\nNext\r\n<\/pre>\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":"
In this article, you’ll see how you can work with Outlook Contacts. We’ll cover various topics such as how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.<\/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-990","post","type-post","status-publish","format-standard","hentry","category-advanced-concepts","category-qtp-concepts","tag-automating-outlook-using-qtp"],"yoast_head":"\nPart 4: Automating Outlook | Working with Outlook Contacts<\/title>\n<meta name=\"description\" content=\"Read how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.\" \/>\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-contacts\/\" \/>\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=\"3 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-contacts\/\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/\",\"name\":\"Part 4: Automating Outlook | Working with Outlook Contacts\",\"isPartOf\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png\",\"datePublished\":\"2012-01-08T15:50:31+00:00\",\"dateModified\":\"2012-01-08T15:51:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20\"},\"description\":\"Read how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png\",\"contentUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.automationrepository.com\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Part 4: Automating Outlook using QTP | Working with Outlook Contacts\"}]},{\"@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 4: Automating Outlook | Working with Outlook Contacts","description":"Read how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.","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-contacts\/","twitter_misc":{"Written by":"Anish Pillai","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/","url":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/","name":"Part 4: Automating Outlook | Working with Outlook Contacts","isPartOf":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage"},"image":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png","datePublished":"2012-01-08T15:50:31+00:00","dateModified":"2012-01-08T15:51:46+00:00","author":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20"},"description":"Read how to access Outlook Contacts, how to retrieve properties (such as name, telephone number, email id etc) from an Outlook Contact, how to search for a Contact, how to create a new Contact, delete a Contact etc.","breadcrumb":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#primaryimage","url":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png","contentUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/outlook-contact-details.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.automationrepository.com\/wordpress\/2012\/01\/automating-outlook-using-qtp-working-with-outlook-contacts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.automationrepository.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Part 4: Automating Outlook using QTP | Working with Outlook Contacts"}]},{"@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\/990","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=990"}],"version-history":[{"count":9,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/990\/revisions"}],"predecessor-version":[{"id":998,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/990\/revisions\/998"}],"wp:attachment":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/media?parent=990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/categories?post=990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/tags?post=990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}