Good morning,
I am looking for a solution to simplify work.

Quarterly, I take data from a spreadsheet (multiple reports merged) and perform a mail merge with a Form I created.

Forms are addressed to the supervisors and displays employee data including response lines for "Approved" and "Denied", as well as the rating/date of their last performance review.

I simplified the old 2 day method into this procedure and greatly simplified time.

The problem is with data collection. I must manually read all 300 emails every quarter and report in a database whether or not the raise is approved.



Is there a better way collect the data after sending via mail merge??

Perhaps some sort of Outlook reporting?
(Im thinking that I can auto merge emails together and it will spit the answers to a report or just some other way.)

I have searched and searched and worked with others and this is just the most efficient and easiest way to do it.

Thanks in advance for any help!!