Auto-Reply to Emails based on their subject line using VBA

Dear Experts,

I would appreciate if someone could help me on this query as I need to regularly work on specific emails on a daily basis which have a redundant task to be done, I was thinking is this were possible to be done using VBA I would not only save time but also have working satisfaction.

There are certain emails with the same subject line such as mentioned below
1. TEST CENTER CONFIRMATION
2. CERTIFICATES RENEWED
3. CERTIFICATES TRANSFERRED

In all the above emails, I need to revert with a STANDARD reply and in the first three emails I have to add a table in the body of the email, this table is the same as the one sent to me with the only difference of 2 more columns added to it at the end. The requirement would be to reply to the 1st three emails with a standard reply such as

"Dear Sender",

"Please find below the details for the test center confirmation of the employee(s) mentioned in your list"

Then the same table with 2 additional columns.


Warm Regards
e4excel