{"id":700,"date":"2011-11-17T00:12:56","date_gmt":"2011-11-16T18:42:56","guid":{"rendered":"http:\/\/www.automationrepository.com\/?p=700"},"modified":"2011-11-18T01:15:42","modified_gmt":"2011-11-17T19:45:42","slug":"how-to-send-emails-using-qtp-from-gmail-and-yahoo","status":"publish","type":"post","link":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/","title":{"rendered":"How to send emails using QTP from Gmail and Yahoo"},"content":{"rendered":"
\n

This article shows how you can use QTP to send mails to any email address using email service providers such as GMail, Yahoo Mail etc. Automatically sending mails through QTP can be a very nice enhancement to your automation framework. For example, after you run your test scripts, you need to email test run reports (number of test scripts passed \/ failed etc) to the stakeholders. You can automate this mailing process and send custom reports to the required people.<\/p>\n

\"Send

Send Email from Gmail and Yahoo Mail<\/p><\/div>\n

Before going through the code, lets go through some important points regarding the code –<\/p>\n

1.<\/strong> The below given email code is not directly related to QTP as such. The code is actually a VBScript function which you can use in QTP. So even if you don’t have QTP, you can use this VBScript code directly.<\/p>\n

2.<\/strong> The email functionality uses Microsoft’s CDO (Collaboration Data Objects) technology to send mails. You can find more details about Microsoft CDO in Microsoft’s MSDN Library.<\/p>\n

3.<\/strong> It is not necessary that you have to use this code using VBScript only. Microsoft CDO can be programmed using any language that creates COM object such as ASP, VB, Visual C++, C# etc.<\/p>\n

4.<\/strong> The below code has been tested on Gmail and Yahoo mail. If you want to use this code in your company’s SMTP server, you need to contact your network team to get details about the SMTP address, port number etc.<\/p>\n

5.<\/strong> To use this code, you don’t need to have Microsoft Outlook installed on your system. You can also use MS Outlook to send emails (we will discuss this in a separate post<\/span> Read how to send mails from MS Outlook using QTP<\/a>).<\/p>\n

Let’s now see the code for sending emails using QTP (VBScript) through Gmail.<\/p>\n

\r\nFunction fnSendEmail()\r\n\r\n'Create an object of CDO type\r\nSet myMail=CreateObject("CDO.Message")\r\n'Enable SSL Authentication\r\nmyMail.Configuration.Fields.Item("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpusessl") = True\r\n'Enable basic smtp authentication\r\nmyMail.Configuration.Fields.Item("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpauthenticate") = 1\r\n'Specify SMTP server and port\r\nmyMail.Configuration.Fields.Item ("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver")="smtp.gmail.com"\r\nmyMail.Configuration.Fields.Item ("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserverport") = 25\r\nmyMail.Configuration.Fields.Item ("http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing") = 2\r\n'Specify user id and password\r\nmyMail.Configuration.Fields.Item("http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusername") = "senders_id@gmail.com"\r\nmyMail.Configuration.Fields.Item("http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendpassword") = "**********"\r\n'Update the configuration fields\r\nmyMail.Configuration.Fields.Update\r\n\r\n'Specify email properties\r\nmyMail.Subject = "Sending Email from QTP"\r\nmyMail.From = "senders_id@gmail.com"\r\nmyMail.To = "some_mail_id_1@gmail.com"\r\nmyMail.CC = ""\r\nmyMail.BCC = ""\r\nmyMail.TextBody = "This is the Text Body"\r\n'Send mail\r\nmyMail.Send\r\nSet myMail = Nothing\r\n\r\nEnd Function\r\n<\/pre>\n
Using the above code, you can send emails to any email id using your gmail address. Just specify your gmail user id and password in lines 14 & 15. Also mention the email id to which you want to send mails in lines 22, 23 and\/or 24.<\/p>\n

\nHow to send mails from your Yahoo mail id<\/strong><\/span><\/p>\n
To send mails using your yahoo mail id, you need to replace the Gmail SMTP address and port number with Yahoo’s SMTP address and port number.<\/p>\n
\r\n'Specify Yahoo SMTP server and Port Number\r\nmyMail.Configuration.Fields.Item ("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver")="smtp.mail.yahoo.com"\r\nmyMail.Configuration.Fields.Item ("http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserverport") = 465\r\n<\/pre>\n

\nHow to send mails to multiple people in one go.<\/strong><\/span><\/p>\n
To send mails to multiple email ids in one go, you need to just enter multiple mail ids separated by a semi colon(;). Example:<\/p>\n
\r\nmyMail.To = "some_mail_id_1@gmail.com; some_other_id@yahoo.com"\r\nmyMail.CC = "some_mail_id@someaddress.com"\r\n<\/pre>\n

\nHow to send html content in the mail.<\/strong><\/span><\/p>\n
Normally you would not send plain text in emails. You would usually be sending some html content in mails. To do so, you need to use HTMLBody in place of TextBody and include html tags in your text body.<\/p>\n
\r\n'myMail.TextBody = "This is the Text Body"  -> TextBody not to be used\r\nmyMail.HTMLBody = "<html><table border=1><tr>Row1<\/tr><tr>Row2<\/tr><\/table><\/html>"\r\n<\/pre>\n

\nHow to send attachments using the email code.<\/strong><\/span><\/p>\n
To add an attachment in you mail, you need to include myMail.AddAttachment line in your code and specify the correct path of the file to be attached. To add more than one attachment, repeat myMail.AddAttachment code required number of times.<\/p>\n
\r\n'Specify email mail properties\r\nmyMail.Subject = "Sending Attachment in Mail from QTP"\r\nmyMail.From = "some_id@gmail.com"\r\nmyMail.To = "some_other_id@gmail.com"\r\nmyMail.TextBody= "Mail Content"\r\n'Send 2 attachments in the mail\r\nmyMail.AddAttachment "D:\\Attachment1.txt"\r\nmyMail.AddAttachment "D:\\Attachment2.txt"\r\n\r\nmyMail.Send\r\nset myMail=nothing\r\n<\/pre>\n
\"Files
Files Attached in Gmail<\/p><\/div>\n
Try out the above code and see if it works for you. In case if you have any queries regarding the code, please use the comments section or the contact form to let us know about the same.<\/p>\n<\/div>\n
\n
If you liked this article, you can join our blog to get the new posts delivered directly in your inbox.<\/p>\n
   <\/p>\n
\n<\/form>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
This article shows how you can use QTP to send mails to any email address using email service providers such as GMail, Yahoo Mail etc. Automatically sending mails through QTP can be a very nice enhancement to your automation framework. For example, after you run your test scripts, you need to email test run reports<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[50],"class_list":["post-700","post","type-post","status-publish","format-standard","hentry","category-advanced-concepts","tag-email"],"yoast_head":"\nHow to send emails using QTP from Gmail and Yahoo - XX<\/title>\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\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/\",\"name\":\"How to send emails using QTP from Gmail and Yahoo - XX\",\"isPartOf\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png\",\"datePublished\":\"2011-11-16T18:42:56+00:00\",\"dateModified\":\"2011-11-17T19:45:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage\",\"url\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png\",\"contentUrl\":\"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.automationrepository.com\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to send emails using QTP from Gmail and Yahoo\"}]},{\"@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":"How to send emails using QTP from Gmail and Yahoo - XX","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\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/","twitter_misc":{"Written by":"Anish Pillai","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/","url":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/","name":"How to send emails using QTP from Gmail and Yahoo - XX","isPartOf":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage"},"image":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png","datePublished":"2011-11-16T18:42:56+00:00","dateModified":"2011-11-17T19:45:42+00:00","author":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/#\/schema\/person\/7a35710e1ce89e5fb481be88fcd6cd20"},"breadcrumb":{"@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#primaryimage","url":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png","contentUrl":"https:\/\/www.automationrepository.com\/wordpress\/wp-content\/uploads\/ar\/gmail-yahoo-mail.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.automationrepository.com\/wordpress\/2011\/11\/how-to-send-emails-using-qtp-from-gmail-and-yahoo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.automationrepository.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"How to send emails using QTP from Gmail and Yahoo"}]},{"@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\/700","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=700"}],"version-history":[{"count":29,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/700\/revisions"}],"predecessor-version":[{"id":740,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/posts\/700\/revisions\/740"}],"wp:attachment":[{"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/media?parent=700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/categories?post=700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.automationrepository.com\/wordpress\/wp-json\/wp\/v2\/tags?post=700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}