Read email content from body of the email, extract and send new email

[Koen_Landewers]

I regularly get emails where I want flow to send a custom reply to the email address that is in the body of the email. The emails are always formatted the same as the example below:

“

Dear Scout,

There is someone who wants to visit your group.

Please contact him or her.

The data:

Unit / Group: <Name organization>

Name:

koen test

Age:

15

Contactinformation: <email addres, addres can and with .com, .nl, be etc.>

<Addres of new visitor>

You'll find

this person in Scouts Online.

Choose Organisation  - New members.

Yours in Guiding

and Scouting

team internet

PS this message is automatically sent

The mailadresss used by the user is: <email addres, addres can and with .com, .nl, be etc.>

“

We would like to send the visitors a custom email based on the organization to the email address that is found in this email. (and if possible, this email attached as .PDF to the custom email).

Flow is still new to me and searching on google for a few hours did not really got me anywhere.

If you got the solution you are my hero!

Greetings, Koen

[ScottShearer]

@Koen_Landewers 

Cal you tell me if the emails that you receive are formatted?  If so, can you post an example (with confidential info blacked out of course)?

[Koen_Landewers]

@ScottShearer 

below a image of how the new emails come in. It looks to me that they are not formatted.

Thu unit / Group name that i mention can be: Bevers, Welpen, Scouts, Explo. If i can get it working for one of the groups I can get it to work for the other ones. But first it needs to read witch group it is so it can send the corresponding message.

-Koen

[Paulie78]

Ideally, if you could post the HTML source of the message and put it on pastebin.com then we could help you build a flow that does what you want. If are receiving this message in Outlook you can go to actions and then view source:

This will give us a true representation of the email as you receive it. If you are worried about posting confidential information, you could fill out of the form that generates this email with a fictitious data. 

[Koen_Landewers]

@Paulie78 

Here is the link to the pastebin: https://pastebin.com/JcTxfEzG

Before i could get to the source code of the email i did need to change the format from Aa Plain Text to Aa HTML. Don't know if that might be an issue.

The email addres used in the form for the vissitor is one of my own organization.

-Koen 

[Paulie78]

Ah ok, if the message was originally plain text anyway, just past the plain text here, but in a code window, to build a flow out of it we need it to be as close as possible to the original. But if it is plain text, that is simple.

[Koen_Landewers]

Good to hear for some it is easy 🙂 Hope you mean this by code window? Did a simple CNTRL+A and pasted it there. The form can come in in 2 languages, Dutch and English. Both have the same layout, only different languages. I don't know how complicaded the flow will be but I think I can make a translation between them.

English:

Dear Scout,

There is someone who wants to visit your group.
Please contact him or her.

The data:
Unit / Group: Scouting Dalfsen Dalflandgroep
Name:
koen test4
Age:
16
Contactinformation: koenlandewers@scoutingdalfsen.nl

0612345678

Engberserf 28, 7722AJ Dalfsen
Notes: 

You'll find
this person in Scouts Online.
Choose Organisation  - New members.

Yours in Guiding
and Scouting
team internet

PS this message is automatically sent

The mailadresss used by the user is: koenlandewers@scoutingdalfsen.nl

Dutch:

Beste Scout,

Er heeft zich iemand aangemeld om te
komen kijken bij jouw groep.
Neem je even contact met haar/hem op?

De gegevens
zijn:
Speltak / groep: Scouting Dalfsen Dalflandgroep
Naam: koen test2
Leeftijd: 14
Contactinformatie: koenlandewers@scoutingdalfsen.nl



Engberserf 28, 7722AJ Dalfsen
Opmerkingen:


Je kunt deze persoon opzoeken in Scouts Online menu Organisatie  - Aangemelde leden.

Met vriendelijke scoutinggroet
Team
Internet

PS dit bericht is automatisch gestuurd

Het door de gebruiker ingevulde mailadres is: koenlandewers@scoutingdalfsen.nl

-Koen