Hi there,
We get a lot of theatre companies emailing us with details of their new show. It takes a lot of time to personally reply to these, and we now have a system whereby they can “apply” to us by filling in some forms.
So I want to be able to email each company and tell them what they need to do.
Trouble is, that they often email someone in our small organisation, so what I would like to be able to do is:
For anyone in our organisation to be able to send any email they receive from a company to an email address tourto@ouremail.com
I would like my scenario to monitor this address and for each new email to find who the original sender was (so NOT the person who forwarded it.
So typically the email arrives at the tourto email address like this:
---------- Forwarded message ---------
From: Gemma XXX <yyyy@gmail.com>
Date: Thu, 25 Jan 2024 at 11:24
Subject: 2024 tour: miniature puppet & folk music show! Ideal for festivals and small settings!
I would like to capture that yyyy@gmail.com and get my scenario to send the email from us, to that address.
I am trying to use the Text Parser to achieve this, but it isn’t working.
Can anyone offer some guidance please?
Thanks
Ian
I have also tried the text parser:
but it doesnt return any email address.
Ian
Hello @Ian_Kerry,
You could try Text Parser Match Pattern with settings something like this:
I’m not the best at RegEx, but the pattern is:
^From: [\w\s]*<((?:[\w\d]*)@ouremail\.com)>$
You would run this on the Gmail’s text output.
Edit: Disregard all that, I read this wrong.
Edit2: Maybe you can use that, just with a slightly different RegEx:
^From: .* <([\w\.-]+@[\w\.-]+\.[\w]+)>$
2 Likes
Hi Donald, many thanks for replying and sorry for the delay in replying.
I can’t seem to get that to work. This is what I hav eput in:
and this is the result
and just checking but i am of course not after who this email is from, but whose email is in the text of the email - the original sender.
Any thoughts?
thanks
ian
Hello @Ian_Kerry,
From your Gmail module #1, you’ll need to locate the “text content” object and click and drag that into the Text field in your Text parser module. The Text field should not contain static text, it should contain the object which contains the text you’re searching.
The regular expression/pattern is designed to pull out the from the first line that starts with “From:”.
2 Likes
Hi Donald, I don’t know if I am being thick, but this is all i see in the Gmail Module 1#
No text content field.
I am beginning to feel I am out of my depth with this scenario.
Ian
Hi @Ian_Kerry,
I’m sorry, maybe I just was not clear.
It’s the output of the Gmail module after it runs, that contains the Text Content amongst all the other information, like who the email is From, etc…
The “Text Content” output needs to be mapped in to the Text field of the Text Parser module. Once mapped it should look like “1.text” (text is the underlying name of that output field) and will be colored.
3 Likes
Ah I think I see:
So in my text parsar I now have this:
but i get an error
Am I getting close? I am not really good at this so feel free to spell it out as if talking to a child!
Thanks again,
Ian
Ah I have made some headway!
I used the same parsar as you said in the beginning.
i put the 1.TextContent from the first gmail module in the Text field of the Text parsar and the pattern you suggested (^From: .* <([\w.-]+@[\w.-]+.[\w]+)>$) into the pattern field.
and it worked!
Thanks for all your help, Donald
Ian
2 Likes
