Question: how to extract data from excel to outlook?
Answer: Open Outlook, go to File > Open & Export and click the option Import/Export.
You'll get Import and Export Wizard. ... 
On the Import a File step of the wizard, pick Comma Separated Values and click Next.
Click on the Browse button and find the . ... 
Click the Next button to pick the destination for your emails.