question

PaulSendor-4821 avatar image
0 Votes"
PaulSendor-4821 asked emilyhua-msft edited

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

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

office-vba-devoffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@PaulSendor-4821

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.