Chapter 6. Integration with Microsoft Office
In this chapter, we will cover the following recipes:
Creating an Excel file
Reading an Excel file
Creating a Word document from a template
Creating a Word document with repeating elements
Creating a Microsoft Project file
Sending an e-mail using Outlook
Introduction
In most of the companies where Dynamics AX is used, people use Microsoft Office Suite too. The new Dynamics AX 2012 and Microsoft Office is now even closer—similar navigation, look and feel, out of the box integration, and so on.
In this chapter, we will pay special attention to the Microsoft Office applications, such as Excel, Word, Project, and Outlook. We will learn how to create and read various Office documents that could be used for exporting/importing business data for further distribution or analysis. We will also see how personalized documents can be created within Dynamics AX from predefined templates. The chapter also discusses about how to export Dynamics AX data as Microsoft...