I am running a script which process thousands of recds,it does take two days to complete the process.Now i want an email sent saying so many recds processed till now.How do i send an email while the script running.Script should email me and should continue.I could not find any email command in manual.Appreciate if any body can mail me if u have the solution.
Hi there, I don't believe Robot has an in-built email capacity. My suggestion would be to write a procedure which generates an email from the locally installed email app & attaches a file with the output you need. It can be done even though Robot recognises lots of MS objects as generic, just make sure there is a unique reliable string parameter or InputKeys sequence for each command:
sub Send_Email(argRecipient, argThisOutputFile)
Close(DefaultEmailApp) 'if you need to
'my test procedure
if EmailRequired=Yes then call Send_Email(Recipient, ThisOutputFile)
I manipulate Outlook & Express only fortunately & they're fairly easy to script...
you will need to have this dll installed on your machine, you can find vbsendmail if you search the web, I'm not sure where our original version came from. Once you have this on the machine you can use something like:
set objSendMail = CreateObject("vbSendMail.clsSendMail")
sMailHost = "MAIL HOST NAME"
i = objSendMail.Ping(sMailHost)
if (i <> TRUE) then
' Add suitable logging to your script for failure to find the mailhost