Hi all, just wondering is anyone drags and drops an Outlook email (only email contents, no attachments) into their clarion app and the app parsing the message into relevant application fields.
I currently get the user to select the contents of the email and paste into a text box and then use String Theory to do the magic on the contents of the paste.
The emails are all standard formats (see below) and are received from an online portal where people enter their request details.
Any pointers would be greatly appreciated.
Thanks
Graeme
Online Portal application (Non personal)
Ref: 231008
An application for the following has been made by:
Organisation: Company name would be entered here
Name: Applicants name would be here
Contact details:
Phone: their phone number would be here
Email: email address would be here
Town/suburb: *****
State/territory: QLD
Postcode: 4000
Country: Australia
Details of request:
Subject matter of the documents the applicant is seeking:
The details of their request/enquiry would be here
This request was made on the Friday 27 October 2023 at 11:33
I do not use Outlook but the search in Internet shows that its drag-n-drop behavior is generally the same as with Thunderbird.
If one drags selected messages outside Thunderbird’s top window, it saves them to EML files in the TEMP directory. This behavior is logical because multiple messages can be selected and dragged.
Try to add the ‘~FILES’ signature to the DROPID attribute of your WINDOW’s control which id a target for dropping. If the dropping of a dragging Outlook message is being allowed after that, Outlook behaves identically to Thunderbird on dragging messages. Your program must parse EML files itself in this case.
Outlook does not behave like Thunderbird. Outlook creates MSG files, not EML.
You can use Devuna OLE Drag and Drop - see: GitHub - Devuna/Devuna-OleDragDrop: Devuna - Clarion OLE drag and drop
Using Devuna you can enable your clarion app to allow dropping an outlook mail. By dropping you will get a MSG file which you then need to interprete to get the message contents. I’m using OLE commands to retrieve the message body from the MSG file.
As an alternative, you could get nettalk to fetch the email, which you could then do as you need.
If those emails all go to a particular account then nettalk getting them should be easy. Even filtering based on subject.