Is there any way to processing the data in the mail to Excell

[buraksari34]

I send bulk e-mails to the company I work for, and with the e-mails I send, I determine the need lists and classify requests. In the Excel file I use for sending emails, column A contains email addresses, while columns B1:G1 contain equipment names, and column H1:H contains notes. For each email in column A (e.g., A10), I manually mark the required equipment in the corresponding row with an "X".
In the emails I send, the content is as follows:

Hi,

If you need any of these equipment, please mark with "X":

[ ] Keyboard
[ ] Mouse

If the recipient replies with "[X]", I want the corresponding "X" to be automatically placed in the Excel sheet at the intersection of the recipient's row and the column of the marked equipment.

In short, ı wanna know how can I automate all these work ? I can automatically send all mails but can't process responds to my Excell sheet. Is there any different way to do this work ?

 

[rowebca]

You have to go with Outlook VBA, so when a [X] is in the body of email to run a script (to change that file, with rules).

Regards,
GB