Hi,

Is it possible to create forms in Excel which can be sent to managers automatically using outlook to collect their responses and update the table accordingly? Their email addresses are in the main spreadsheet

The spreadsheet contains over 10,000 entries and these entries need to be sent to be verified by managers. Please see attachment which includes a mock up of sample spreadsheet (TABLE 1) and a form template (FORM 1) that I'm hoping to create in order to collect their responses. Their replies should be reflected in the main spreadsheet table (Column K to P)

excel.docx

Any suggestions and guidance would be welcome and appreciated.

Thank you in advance