I'm trying to accomplish what I had thought to be a
relatively simple procedure but I got a bit complicated
so any help would be appreciated.
What I'm trying to create is a daily/weekly (doesn't
matter) task that will check my email (POP), identify
emails with a specific non-changing Subject, parse it and
copy contents into an excel file (add row with values).
The email comes in a fixed format where each line has a
prefix and contents like "Name: John Doe" and there are
always 4 lines with the same prefixes.
What I want to do is basically create a new row in an
excel file, and copy each line content to the appropriate
column (column A through D).
I saw how to define the email pull, I saw how to trigger
but everything in between I can't figure out (identifying
the specific emails, copying the content, pasting to
excel, closing the file, etc)
What I figured needs to happen is that I do Download
Email, then Parse Email (no idea how to tell it to parse
only the new emails downloaded in the previous action or
at all) to find the emails with the proper subject, then
parse again each email, then do STR Extract for each line
I want and store in a new variable, then somehow open the
excel file and put each variable inside a new row in the
appropriate column. MOUTHFUL
Help?
Thanks so much in advance!