Examples of using SET to parse incoming email

tford

Can anyone provide sample rules for processing incoming email using the SET action. Or perhaps does anyone know if any of the sample apps use SET?

I'm attempting to use it for the first time & getting tripped up.

customaware

Hi Tom,

I use it like this.....

I send an email with an attached report of all Leave Applications approved by that person in the last month.

This idea is they print it, sign it and then send it back as an attachment in a reply to the email they received in the first place.

So, in the Subject of the outgoing email....

ApproverName#<<RegularUser.DisplayName>>#FromDate <<FIRST_DAY_OF_MONTH(DATE_ADD(CURRENT_DATE,-1))>>#ToDate#<<LAST_DAY_OF_MONTH(DATE_ADD(CURRENT_DATE,-1))>>

When they send back the signed for then their Subject is likely to have a Re: or a Fwd: at the start....So, I strip them
off and then use the remainder of the Subject Line to populate a new record for the received response....

ReceivedEmail.Subject=REPLACE_PATTERN(ReceivedEmail.Subject,'Re: ','')
ReceivedEmail.Subject=REPLACE_PATTERN(ReceivedEmail.Subject,'Fwd: ','')
CREATE ReturnedApproverApprovals WITH ReturnedApproverApprovals.DateReceived=CURRENT_DATE,ReturnedApproverApprovals.SignedApprovalForm=ReceivedEmail.Attachment1
SET ReturnedApproverApprovals FROM ReceivedEmail.Subject

Hope that helps.

MC&HNY

tford

HTML in my email message was causing issues.

Did some additional testing & the problem is that I was sending an email from AwareIM to Gmail (using a Plain Text message attribute), then clicking replay on the Gmail to send it back to AwareIM.

Gmail was adding in HTML to the reply.

Prelim tests sending the same email to an email account on our Exchange server did not have the same issue of adding HTML to the reply.