Chapter 10. Connecting Dynamics GP to Microsoft Office 2016

Dynamics GP provides tight integration with Microsoft Office 2016 across multiple integration points. Chapter 5, Exposing Hidden Features in Dynamics GP, looks at the options for connecting Dynamics GP with Office. We will see the following recipes:

• Building analysis by exporting SmartLists to Microsoft Excel

• Getting fine-grained control of Excel Exports from Navigation lists to Excel

• Improving reports by sending SmartLists to Word

• Communicating with customers using Letters from Microsoft Word

• Skipping the exports by using pre-built Excel Reports

• Delivering the goods with Excel-based dashboards

• Reporting on any Dynamics GP data with direct Excel connections

• Importing data with Microsoft Word and a Dynamics GP Macro

• Getting fine-grained control of Excel Exports from SmartLists

• Gaining flexibility by printing documents from Microsoft Word