I am trying to find the answer for this and have not found anything that works for this specific topic.
So, I have a list with different company names on it. I want each company to fill in their prices in this list. Once I have the list I want excel to automatically send each company the rows concerning that specific company an email in outlook. In this email I want to ask them to fill in the prices in a specific column. When they respond and fill in the column in the email I want that column to automatically be updated in the excel sheet. How do I do this? So basically extract data from excel to outlook (it can be in the mail or it can be an attached excel file). When they fill in the table I want outlook to extract that data back to excel and update the sheets.