Pages

Wednesday, November 6

Send Outlook Email (with text formatting) using QTP

Hello Friends!!

In this post we will quickly see how to send an outlook email.
I know, most of you all know how to send email using QTP, then why this post??

Well, here we will see how to use HTML code to format your email's body i.e. text style, font color, formatting etc. Here we go!!

Dim oOutlook, oEmail, vEmailTo, vEmailCC, vEmailBCC

vEmailTo = "catchall1@email.com"    'replace  this with your email id
vEmailCC = "catchall2@email.com"
vEmailBCC = "catchall3@email.com"
vEmailSubject = "Test Email from QTPschool.com"

Set oOutlook = CreateObject("Outlook.Application")
Set oEmail = oOutlook.CreateItem(0)

oEmail.To = vEmailTo
oEmail.CC = vEmailCC
oEmail.BCC = vEmailBCC
oEmail.Subject = vEmailSubject

oEmail.HTMLBody = "<HTML>"&_
"<Body>"&_
"<p Style=""background-color:red""><b>This text is bold and red background</b></p>"&_
"<p><strong>This text is strong</strong></p>"&_
"<p><em>This text is emphasized</em></p>"&_
"<p><Font color=""green""<i>This text is green and italic</Font></i></p>"&_
"<p><Font color=""red"" size = 16><small>This text is red and big!</small></Font></p>"&_
"<p>This is<sub> subscript</sub> and <sup>superscript</sup></p>"&_
"</Body>"&_
"</HTML>"

wait 2
oEmail.Send
wait 2

Set oEmail = Nothing
Set oOutlook = Nothing


'For more details on HTML code, please visit http://www.w3schools.com/html/html_formatting.asp

In case of any queries, please post your comments. Happy QTPing!!


19 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Hi abhihshek,
    Thank you the for code.
    but want to type three line in outlook using for loop
    for example

    Test Set -1
    Total Passed =20
    Total Failed = 3

    Test Set -2
    Total Passed =21
    Total Failed = 2

    Test Set -3
    Total Passed =29
    Total Failed = 2

    .. like this for all the test set executed.
    could you please help with the code or an idea so that i can implement in my driver script.

    Thanks In Advance.
    Gautam Grover
    gautamgrover88@gmail.com

    ReplyDelete
  3. Many a times, important documents are shared through emails. In that case email document management becomes a requirement. Not to worry as Grexit makes email document management fast and easy. Grexit brings to you a secured way of email storage and customer email management.
    http://800supportnet.deviantart.com/art/Password-Change-How-do-I-change-My-Google-Account-620293603?ga_submit_new=10%253A1467953049

    ReplyDelete
  4. I appreciated your work very thanks hotmail.com

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Utilizing 'Viewpoint Connector,' booked to be accessible worldwide in the not so distant future in 11 dialects, buyers can see and deal with their records from Outlook for nothing, with full contact, email, and email envelope synchronization. iniciar sesion hotmail

    ReplyDelete
  7. Useful post, thanks! I want to recommend one great tool that reveals personal emails and phone numbers from social networks: improver.io — check it out!find email from linkedin

    ReplyDelete
  8. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info  Plagiarism detector

    ReplyDelete
  9. The email benefit is additionally effectively accessible as you simply need to drop a mail and the officials will return quickly with the correct solution for your answer. Hotmail

    ReplyDelete
  10. I think that thanks for the valuabe information and insights you have so provided here. hotmail email login

    ReplyDelete
  11. Outlook email takes up a lot of time. Estimates vary on exactly how much time we spend email. But the above method save even just a little bit of time on a lot of tasks, those times savings can really add up. Random Password Generator Online

    ReplyDelete
  12. Post your offers and email sign-up links on Google+. You can also add links on About section on your Google+ profile.Email List for Marketing

    ReplyDelete
  13. It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait reading. I am impressed with your work and skill. Thanks. visit this site

    ReplyDelete
  14. New web site is looking good. Thanks for the great effort. ActiveCampaign Sales Automation

    ReplyDelete
  15. Im no expert, but I believe you just made an excellent point. You certainly fully understand what youre speaking about, and I can truly get behind that.
    email search tool

    ReplyDelete
  16. hello!! Very interesting discussion glad that I came across such informative post. Keep up the good work friend. Glad to be part of your net community. email search tool

    ReplyDelete
  17. Thanks for your insight for your fantastic posting. I’m exhilarated I have taken the time to see this. It is not enough; I will visit your site every day. visit this site

    ReplyDelete
  18. thank you for this such a good information about hotmail email login on www.hotmail.com

    ReplyDelete