Microsoft® Access® 2010 VBA Programming Inside Out

Chapter 13. Integrating Microsoft Office

• Working with Objects and Object Models

• Connecting Access to Word

• Connecting Access to Excel

• Connecting Access to Outlook

If you are building applications that will be deployed in an environment containing other Microsoft Office products, you can pick and choose from the strengths of each Office product and produce a more integrated solution. Because Microsoft VBA is a universal language for the Office family, you have flexibility to program in the different products.

For example, in a project management system built in Microsoft Access 2010, you can integrate with Microsoft Outlook to produce and log outgoing emails together with any incoming emails in the database. You can also synchronize contact details between ...