Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sending QTP report to mail
#1
Solved: 10 Years, 8 Months, 3 Weeks ago
Hi

Please any one can let me know

How to sent the report generated by the QTP to our mail box

any specific code for that..

I tried with the report functions they are not so helpfull to me

Regards
Vamshi
Reply
#2
Solved: 10 Years, 8 Months, 3 Weeks ago
Hi,

Please try the following vb script and change the ToAddress and other variables accordingly. I think this will help you.

Code:
'=========================================================================

'Email generation VB Script snipet.
'NamitRayudu
'Pre requisite: MS Outlook apllication up running on the desktop
'----------------------------------------------------------------------------------

Dim ToAddress
Dim Subject
Dim Body
Dim Attachment
Dim oUtlookApp, nAmeSpace, newMail

'SystemUtil.Run "C:\Program Files\Microsoft Office\Office11\OUTLOOK.EXE" 'This line should be enabled if the Outlook on the desktop is not running

ToAddress = "abc@test.com" ' Message recipient Address

Set oUtlookApp = CreateObject("Outlook.Application")

Set nAmeSpace = oUtlookApp.GetNamespace("MAPI")

Set newMail = oUtlookApp.CreateItem(0)

Subject = "This is a test mail" 'Message Subject you can update

Body = "This the message for testing. " 'Message body you can update

newMail.Subject = Subject

newMail.Body = Body & vbCrLf

newMail.Recipients.Add(ToAddress)

newMail.Attachments.Add("C:\worklist.txt") 'You can update attachment file name

newMail.Send

Set nAmeSpace = Nothing

Set oUtlookApp = Nothing

'end of the email generation code===================================================================

Thanks,
NamitaRayudu
Reply
#3
Solved: 10 Years, 8 Months, 3 Weeks ago
Thank you very much

vamshi
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Need help on rdlc report automation using uft souvikghosh_diatm 0 1,209 05-25-2017, 09:51 PM
Last Post: souvikghosh_diatm
Rolleyes Urgent help with Gmail Sending mail feature nidhitaneja 2 2,736 03-05-2014, 09:39 PM
Last Post: nidhitaneja
  How To pick up the particular mail in Post Login Gmail page and click on Checkbox akhandesh 0 2,695 12-02-2013, 01:35 PM
Last Post: akhandesh
  Jasper Report Automation TAUSIF 0 4,904 10-03-2013, 03:30 PM
Last Post: TAUSIF
  Query for configuration of Mail Body section through VB/QTP prasanna.rathinam 1 2,859 09-19-2013, 12:03 PM
Last Post: ssvali

Forum Jump:


Users browsing this thread: 1 Guest(s)