How to Extract Invoices from Outlook Automatically

Invoices pile up in Outlook faster than anyone files them. Some arrive as tidy PDFs. Some are HTML receipts with no attachment. Some bounce through three people before they hit ap@. Doing anything useful (pay, code, hand to your accountant) starts with getting them out of the inbox in an organised form.

This is the Outlook / Microsoft 365 playbook. The cross-client overview lives in extract invoices from email automatically. Gmail users should use the sister guide: extract invoices from Gmail.

How do you extract invoices from Outlook automatically?

Most frustration here comes from picking a method that only does a smaller job than expected. Three distinct jobs get lumped under one question:

1. File the emails into an Invoices folder (Outlook rules).
2. Save the PDF files to disk, OneDrive, or SharePoint (manual, macro, or Power Automate).
3. Extract the data into structured fields, then Sheets / Drive / ledger.

Outlook is strong at (1) and decent at (2). It barely does (3) unless you add licensed AI Builder or a dedicated capture tool. TallyScan covers (3) with a privacy-first forward: Outlook rules send only billing mail to a dedicated address. No Microsoft mailbox OAuth required.

Method 1: An Outlook rule to file invoices

The five-minute cleanup:

1. Outlook on the web: Settings → Mail → Rules (desktop: Rules → Manage Rules & Alerts).
2. Add new rule, name it something like Invoices.
3. Condition: subject includes invoice / receipt, or From known suppliers. Add several conditions if needed.
4. Action: Move to a folder named Invoices (create it first).
5. Save. Matching new mail files itself.

What you get: a quieter inbox.
What you do not get: opened PDFs, extracted totals, or HTML-body coverage. Keyword rules also miss “Your order” and non-English subjects while sweeping in newsletters that mention invoicing.

Method 2: Saving the attachments

If you mainly want files:

• By hand: open mail → save attachment / Save All Attachments. Fine for a quiet week; painful at month-end.
• Desktop VBA macros: can auto-save from a folder to disk. Desktop-only, fragile across Outlook updates, and you still own a script finance rarely wants to maintain. You end up with invoice (3).pdf and zero structured data.

Saving files is not extracting invoices. It is creating a better shoebox.

Method 3: Power Automate to OneDrive or SharePoint

This is what most people mean by “automate Outlook invoices” inside Microsoft 365.

Core cloud flow sketch:

1. Go to Power Automate → Create → Automated cloud flow.
2. Trigger: When a new email arrives (V3) on your Outlook mailbox.
3. Set folder, Include Attachments = Yes, optional subject/sender filters.
4. Get Attachment + Apply to each.
5. Create file in OneDrive for Business or SharePoint (map name + content).
6. Filter to .pdf (and maybe .png invoices). Power Automate treats signature logos as attachments; without a type/size filter you drown in stray PNGs.
7. Save and test with a real supplier email.

Strength: central, searchable store many Microsoft shops already use.
Limit: you still have organised PDFs, not vendor / amount / tax / line items in a sheet, unless you add AI Builder invoice models (separate licence, real project to tune). Subject filters remain brittle. Portal-only vendors never appear. For a OneDrive-focused filing guide (manual + automated), see upload invoices to OneDrive.

What native Outlook methods cannot do

Gap	Rules	Save / Power Automate
Structured field extraction	No	Only with AI Builder bolted on
HTML / plain-text body receipts	Missed	Attachment flows skip them
Stable detection without keywords	Weak	Weak
Portal invoices never emailed	No	No
Backlog already in the mailbox	Rules are forward-looking	Flows are forward-looking

For a handful of predictable PDF senders, rule + Power Automate is reasonable. Past that you maintain flows and still type data. That is when a purpose-built extractor pays for itself. Tool landscape: automated invoice capture software.

Which approach should you use?

Situation	Start with
Few regular senders, just declutter	Outlook rule
Want PDFs in OneDrive/SharePoint, M365-comfortable	Power Automate + PDF filter
Need data entered, HTML bodies, or privacy without mailbox OAuth	Dedicated forward + AI extraction
Already closing in Xero/QBO with clean PDFs	Also consider each ledger’s built-in email-in (Xero, QuickBooks)

Privacy-first path: Outlook rules → TallyScan

TallyScan does not require connecting Outlook via Microsoft OAuth. You keep Microsoft’s rules engine; only selected messages leave the mailbox.

Setup

1. Create a TallyScan account and copy your dedicated forward address.
2. In Outlook, create a rule: known billing senders (or a starter subject list) → Forward to your TallyScan address. Keep a copy in Invoices if you want a local trail.
3. For Microsoft 365 tenants, confirm external forwarding is allowed (admins sometimes block auto-forward).
4. Forward one Stripe-style HTML receipt and one supplier PDF as a test.
5. Sync outputs to Google Sheets, Notion, Google Drive, or OneDrive on Starter+. QuickBooks / Xero sync is Beta on Pro.

Signed-in users can also follow the in-app Outlook forward checklist under email-forward setup.

Compared with Power Automate + AI Builder

	Power Automate path	TallyScan forward path
Moves PDFs to OneDrive	Yes	Via Drive/OneDrive sync after extract
Reads invoice fields	AI Builder project	Included AI extraction
HTML body receipts	Usually no	Supported where the tool reads bodies
Mailbox OAuth to a capture vendor	N/A (Microsoft stack)	Not required
History sweep	No (forward-looking)	Forward/upload backlog deliberately

Pro Tip: Build the first rule from a real AWS or Stripe message, not from an imagined subject line. Clone the rule per top vendor after a clean week.

Shared mailboxes and common failure modes

• Shared accounts@: put the rule on the shared mailbox, not three personal inboxes.
• Inline invoices: attachment-only flows miss them; test body extraction early.
• Duplicates: colleague forward + original send; prefer tools with dedupe before ledger sync.
• History: turning automation on today does not clear last year’s Outlook. Bulk-forward or upload PDFs if you need a catch-up.
• Signature image spam: always filter Power Automate on file type/size.

Frequently Asked Questions

Can Outlook automatically save invoices?

Yes, partly. A rule can file mail; Power Automate can save attachments to OneDrive or SharePoint. Neither extracts fields by itself.

How do I create a rule in Outlook for invoices?

Settings → Mail → Rules → add a condition (subject or sender) → move or forward. Refine with real vendor mail after the first week.

Can Power Automate extract invoice data from Outlook?

It can save files easily. Field extraction usually means AI Builder (extra licence and setup) or a dedicated capture tool.

How do I extract invoices from Outlook without Power Automate?

Forward matching mail to an AI extraction address (TallyScan), review fields, sync to Sheets/Drive/OneDrive or try ledger sync (Beta).

How do I download invoices already sitting in Outlook?

Native automation is mostly forward-looking. Search the backlog, forward or download PDFs in batches, or upload files to your capture tool.

Does Outlook have built-in invoice OCR?

Not in Outlook itself. OCR/extraction comes from AI Builder or third-party tools. See best invoice OCR software for category context.

File less, extract more

Use Outlook for what it is good at: rules and Microsoft storage. When you need structured AP data without handing over the whole mailbox, forward billing mail into TallyScan and keep month-end as a review. Pricing scales with volume.