Email Parser

I have a table named Outgoing. It has the following fields:
SQN, EMAILADDRESS, SUBJECT, CONTENT, TRIES, SUCCESS, TIMESTAMP

I want an action that runs after a MySQl database action is successfully run. It should do the following:

1. Send an email to each EMAILADDRESS in the table where TRIES < 4 and SUCCESS = 0. The subject and body of the email are taken from the fields SUBJECT and CONTENT respectively.

2. For each email sent successfully to "EMAILADDRESS" update the field SUCCESS to "1" and TRIES to "TRIES+1" for the corresponding EMAILADDRESS

3. For each email NOT sent successfully to "EMAILADDRESS" the field SUCCESS should remain at "0" for the corresponding EMAILADDRESS and automatically retry to send the email up to 3 times at 2 minute intervals.

4. Update the field TRIES to "TRIES+1" at each send attempt, whether successful or failed.

5. Update the field TIMESTAMP with the time and date of each send attempt, whether successful or failed.

I configured the system using the example image you gave. I am getting the following error (please refer to the example image you gave me):
1. Get email addresses - No problem. I get 4 sets of results as expected. The test passes. (this is a query that does selects email addresses from a table)
2. For each email address - When I test this action it finds only one set of results, and the set is empty. The test runs and finishes with no error, which I guess means it is not finding anything from the previous action. I configure this action to take fields from the previous action (1 above), so I would expect to get 4 sets of results.
3. Send email- Gives the error message "No sender specified for the mail message" when I run it after action 1 or action 2. This I guess means it is not finding anything from the previous action.

So I am not able to send an email to email addresses from the database table.

However, 2 and 3 work well when I manually enter values for email address and other fields.

Where am I going wrong?

I could not upload the file with settings because of file size limitation. My file is 260KiB. I am getting the following error:
"The file is too big, maximum allowed size is 256 KiB."

So have send the file by email with subject "Action to Send Emails Problem" to:
support@EmailParser2Database.com

I have observed 2 things:
1. fields from the Regular Expression parser are not being inserted into the database table. However, fields from email address are inserted into the table.
2. The action to send email is accepting fields from an email (eg "from"), but not from the Iterate action

NOTE: I am using two different tables here: first table "test" to insert fields from Regular Expression parser, second table "log" to get email addresses from.

I have also observed that Email&Parser is not "writing to text file" or "inserting into Excel file" the fields extracted by the regular expression

This is the output of the parser:

Parsing email....
1 value found for the field M0.
1 value found for the field M1.
1 value found for the field M2.
1 value found for the field M3.
1 value found for the field M4.

The email parser produced the following results:
M0: What
M1: the
M2: Heck
M3: is
M4: a Regular Expression Anyway?

The output of the Action is shown below. Notice that only email headers are added into the Excel file; the same applies to Insert into database and text file:

········ Running Action-5
Opening Excel file C:\Users\A Marema\Desktop\EmailParser.xlsx
Adding cell M0:
Adding cell M1:
Adding cell M2:
Adding cell M3:
Adding cell M4:
Adding cell To: example@example.com


Finished

I emailed the configuration file from:
sdfungayi@gmail.com

I ran the Email&Parser program in a "live" environment using an actual email source and it works fine.

Previously I was only running it in "test" environment using a dummy email source; it was not extracting text as expected. I believe the "test" environment should give results similar to the "live" environment.