Skip to main content

making my script read or write in my mail application

  • August 9, 2018
  • 6 replies
  • 0 views
D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba

6 replies

D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba

Hi besafe,

I'm not sure reading emails from Rumba Script is a really good idea, can you give an overview of your requirements and how you would envisage such a solution working?

Here is a short macro which demos how to create and to send an email from Rumba basic via MS Outlook.

Sub email()
   Dim App As Object
   Dim Itm As MailItem
   Dim myattachments As Object
   Set App = CreateObject("Outlook.Application")
   Set Itm = App.CreateItem(0)
   Itm.display
   Itm.Subject = "Your Extra! Screen"
   Itm.To = "besafe@myFavouriteCustomer.com"
   Itm.HTMLBody = "<p>" & "Good morning besafe</p><p>"
   Itm.send
End Sub

Tom

D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba

Hi besafe,

I'm not sure reading emails from Rumba Script is a really good idea, can you give an overview of your requirements and how you would envisage such a solution working?

Here is a short macro which demos how to create and to send an email from Rumba basic via MS Outlook.

Sub email()
   Dim App As Object
   Dim Itm As MailItem
   Dim myattachments As Object
   Set App = CreateObject("Outlook.Application")
   Set Itm = App.CreateItem(0)
   Itm.display
   Itm.Subject = "Your Extra! Screen"
   Itm.To = "besafe@myFavouriteCustomer.com"
   Itm.HTMLBody = "<p>" & "Good morning besafe</p><p>"
   Itm.send
End Sub

Tom

D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba
its because i have some data, which should be sent to customers, right now i am storing the information in excel and then putting it manually into a mail and sending it out, but if it was possible to write and send the mail right away and automating the process it would just make everything a lot easier
D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba
sometimes i also get data from users which should be inserted in my own main frame, but if this could be done automatically, it would be way easier
D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba
Hi besafe,

the sample I provide above should allow you to add the data you scrape from the display terminal to the body of the email and to set the distribution list, you can have several email addresses, separated by a semi colon ";"

e.g. "besafe@yahoo.com;bebold@google.com;bebrave@microfocus.com"

Also you can attach files to the email

e.g.
Itm.Attachments.Add "C:\\Temp\\besafe.xlsx"

If I were you I'd scrape the date into Excel, save the spread sheet and email that. This gives you the opportunity to send the email from Excel VBA (the same code as above should work). By doing it this way you can sanitise the data manually before you send the email, and the data will likely be easier to consume at the other end.

But that's your call.

Tom
D

Hello community,

I was wondering if it is possible to make the script go and read from other applications, right now i only know that it is possible to make it read from our mainframe and from excel, but if its possible i would really like it to go and read through mails and maybe also send mails

so if it is possible can anyone then show how you would open a mail application and then either read or write mails


#Rumba
Hi besafe,

this is doable, however it will require the date to be formatted consistently every time you receive an email.

e.g.
You can use either the "From" or the "Subject line" to identify the mail. This will then be tied to a "data template" which would parse the date from the email.

Automating this would need a backstop, whereby any email with does not adhere to its relevant "data template" would need to be manually processed. Again I would advise that rather than use the body of the email, get the people sending these emails to use an template Excel spreadsheet to submit the data, this way you can try and force some kind to predetermined format and minimise manual intervention.

The last thing you want is bad data being written to your mainframe, especially if you are automating the extraction of the data at a later stage, that is assuming you can cleanly write the bad data to your host screens, without encountering -key board lock errors and entering alphas into numeric fields etc, etc..

Tom

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement