CODEWITHSUNDEEP
excelimportoutlook
Michael O'Hara
Michael O'Hara

Reputation: 33

Exporting contents of emails to Excel/Google Sheets

I have quite a few emails that come in on a regular basis with the same email subject (around 10-20 a day) that all follow a set format, and then are manually being entered onto a Google Sheet for Sales staff to access.

Ideally, if I could cut this out of my morning routine it would make my life a lot simpler.

What would be the best way to search Outlook by subject line, and then export the relevant data to an Excel worksheet, so that all I would have to do is import that .xls file onto the shared sheet?

Upvotes: 0

Views: 78

Answers (1)

Eugene Astafiev
Eugene Astafiev

Reputation: 49395

You may consider developing a VBA macro or add-in if you need to install the solution on multiple PCs. See Getting Started with VBA in Outlook 2010 for more information.

Upvotes: 1

Related Questions