How to automate data from new emails to import into my excel spredsheet

Question

I'm trying to set up a budgeting plan for myself and a few others, I wanted to automatically pull data from incoming emails from my bank about my balance, I don't really want to include anything from the email apart from the actual balance though, is that possible? I'm really bad at explaining stuff so please do ask questions if you have them

Answer 1

@Paul Sendor

Based on my knowledge, if the email address is for an organization, we could get data from Microsoft Exchange Online or Microsoft Exchange into Excel Power Query.
But this feature is not applicable to personal mailbox.

I find an artile online, "How To Import Your Outlook Emails Into Excel With VBA" this may provide a direction for research.
(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

To better help you, I would add the tag "office-vba-dev", besides, as tag "office-excel-itpro" focus more on general issue, issues related to code are out of our support scope, I would remove it.

Thanks for your understanding.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.