How to copy MS Outlook mail data to MS excel using ASP .Net code ?

Question

i want to copy my volume report which is in outlook mail to excel file, Please help me guys

Answer 1

You can retrieve your emails using EWS service, filter the emails by its subject, read the content, attachment as well if required, and generate the excel file.

Answer 2

Exporting emails from Outlook to Excel is easy. Keep in mind, however, that you will only retain plain text and basic links. All other formatting is lost. If you eventually want to restore formatting, saving as HTML files is a good alternative.

Open Outlook and click the “File” option, followed by the “Open and Export” option. Click “Import/Export” and “Export to a File” before setting the file type to Excel. A CSV is similar, and will transfer easily to an excel workbook later if you wish.

Finally, choose the destination folder where the file should be saved. Select “Finish” to save the emails into the specified folder. Exit Outlook and navigate to the folder. Check to ensure the file is saved and attempt to open it. The Excel workbook or CSV file should open with all the email data.

Regards,
Peter