Can someone please help me on how we can connect to MS Exchange Server to retrieve email to MS Excel through backend to execute power query on the extract list of emails?
Manual procedure to export email to Excel:
- Open MS Excel
- Click on Data ->Get Data-> From Other Sources → From Microsoft Exchange
- Input your Microsoft exchange server email address
- Select Microsoft account tab and sign-in to your microsoft exchange server using your MS exchange server credentials and click on connect.
- Select Mails & click on Load to load all emails to excel.
- Now execute power query on list of email to fetch required information from specific
Attaching screenshots for reference.
Thanks & Regards,
Venkata Pramod Chandra