CODEWITHSUNDEEP
excelimportoutlook
user974061
user974061

Reputation: 363

Export Outlook message body number to Excel

Each day I have to open approximately 30 emails and take one number from each email and place it into an Excel sheet. I have found how to use Access to import the Outlook emails and retrieve the number I need. But that means using Access imported to Excel.

Can I do something similar with just Excel?

Upvotes: 0

Views: 222

Answers (1)

Cody Hayes
Cody Hayes

Reputation: 26

Was trying to get message body from Outlook for Office 365 without success; copying the view still did not isolate message body to a single cell. Frustrating!

Then I recognized it was possible to "get data" "from microsoft exchange." Problem Solved!

Connect to Exchange (Power Query) Use Excel's Get & Transform (Power Query) experience to connect to a Microsoft Exchange server.

Click the Data tab, then Get Data > From Other Sources > From Microsoft Exchange. If you don't see the Get Data button, the click New Query > From Other Sources > From Microsoft Exchange

Power Query Data Sources

Next

1.In the Access an Exchange Server dialog box, specify your Email Address and Password.

2.Click Save.

3.In the Microsoft Exchange Autodiscover Service dialog box, select Allow to allow the Exchange Service to trust your credentials.

Upvotes: 1

Related Questions