Outlook, meet Excel.
May 20, 2018 9:26 AM   Subscribe

How can I get an Outlook account to write to Excel?

I need to get a way for an Outlook-based e-mail box to automatically write incoming email addresses and subject lines into an excel file. I feel like this should be easier to do, but I can't figure it out for the life of me. Any ideas?
posted by Vhanudux to Technology (3 answers total) 1 user marked this as a favorite
 
Best answer: You can also use Visual Basic for Applications to achieve the automatic part, if you are willing to copy/paste some script and turn on macros.
A Google search like "VBA Export Outlook to Excel" returns some good examples, like:
How to import your outlook emails into excel with vba

Good luck!
posted by smuna at 10:14 AM on May 20, 2018 [2 favorites]


Yes, visual basic is just what you want.
posted by dbx at 7:41 PM on May 20, 2018


IFTTT has an Outlook to Google spreadsheet option.

https://ifttt.com/applets/415798p
posted by toomanycurls at 7:53 PM on May 20, 2018


« Older Old school Thailand beach huts   |   TSH high but no antibodies present. What does it... Newer »
This thread is closed to new comments.


Tags

Share