Copying Outlook mail message into Excel

Hello Excel Experts,

My requirement is to copy Outlook mail message into Excel.

I have a VBA coded excel sheet which helps me sending mass emails to all my customers at just one single click. Entire table i.e. B2:D12 gets copied to Outlook email body.

Requirement : (refer to attached sheet)

1. Once email gets delivered to customer, they review and update any new information in column D.
2. All emails received are moved to a backup folder (which is named as Backup Folder) within outlook.
3. Subject is the same for all the emails which is sent to 1000+ customers.
4. Now - I want to copy Outlook mail message into excel which is last sent bu customer.
5. The data which is sent and received is in table format (Column format). I want the data should get copied in Transpose format into Excel customer by customer (see F2:O3)

Note : As my requirement is different from the coding mentioned in the attached sheet so I've removed the the VBA coding from the attached sheet.

Regards,
E5254730