Summary
Description
Sage software has the flexibility to integrate with Microsoft Office in several ways. You're able to email your documents, quickly send accounts data to Microsoft Excel and Excel Integrated Reporting (EIR).
To use these features, use a compatible version of Microsoft Office that you install locally on the same computer as your Sage software.
NOTE: EIR is only compatible with 32-bit Microsoft Office. You can only use integrated Microsoft 365 features with Sage 50 Accounts. Go to the Sage Help Centre for further support.
Google and Microsoft changes
These providers retired basic authentication in September 2024. If you use either of these in your Sage software to send emails via SMTP, you need to update your settings.
For more information, visit our changes to SMTP email authentication affecting Sage software guide.
Check if your versions are compatible
- To check your Sage 50 version number, within your software - on the menu bar go to Help, then About
- To find out the version of Office you're using, go to support.microsoft.com
IMPORTANT: If you use the 'new look' Outlook, revert back to the classic style. The new look version isn't compatible with Sage 50 software.
To check if you're using the new look outlook, check the top right of the window, see the screenshot below:
Select your product below:
▼ Sage 50 Accounts
NOTE: The symbol ⚠️in the chart means the version is compatible with the ▼ Following features
If these versions are 64-bit, you must Install the 64-bit ODBC driver.
Office version | v31 64-bit | v31 32-bit | v30 64-bit | v30 32-bit | v29 |
v28 | v27 v26 |
---|---|---|---|---|---|---|---|
Office 2016 32-bit | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Office 2016 64-bit | ✔️ | ⚠️ | ✔️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |
Office 2016 Click-to-Run | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |
Office 2019 32-bit | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Office 2019 64-bit | ✔️ | ⚠️ | ✔️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |
Office 2021 32-bit | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Office 2021 64-bit | ✔️ | ⚠️ | ✔️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |
Microsoft 365 - Cloud based | ❌ | ❌ | ❌ | ❌ | ❌ | ❌ | ❌ |
Microsoft 365 - 32-bit - Desktop based | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Microsoft 365 - 64-bit - Desktop based | ✔️ | ⚠️ | ✔️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |
Trial, student and not for business use versions | ❌ | ❌ | ❌ | ❌ | ❌ | ❌ | ❌ |
▼ Sage 50 Payroll, Sage 50 P11D and Sage 50 HR
You can email documents using SMTP settings for common email providers if you're using a non-compatible version of Outlook.
Compare your version number with the chart below to see which Microsoft Office it is compatible with.
Office version | Payroll v30 | Payroll v29 | P11D v29 | HR |
---|---|---|---|---|
Office 2016 32-bit | ✔️ | ✔️ | ✔️ | ❌ |
Office 2016 64-bit | ✔️ | ✔️ | ✔️ | ❌ |
Office 2016 Click-to-Run | ✔️ | ✔️ | ✔️ | ✔️ |
Office 2019 32-bit | ✔️ | ✔️ | ✔️ | ❌ |
Office 2019 64-bit | ✔️ | ✔️ | ✔️ | ❌ |
Office 2021 32-bit | ✔️ | ✔️ | ✔️ | ❌ |
Office 2021 64-bit | ✔️ | ✔️ | ✔️ | ❌ |
Microsoft 365 - Cloud based | ❌ | ❌ | ❌ | ❌ |
Microsoft 365 - 32-bit - Desktop based | ✔️ | ✔️ | ✔️ | ❌ |
Microsoft 365 - 64-bit - Desktop based | ✔️ | ✔️ | ✔️ | ❌ |
Trial, student and not for business use versions | ❌ | ❌ | ❌ | ❌ |