Skip to Main Content
Microsoft® Access® 2010 Programmer's Reference
book

Microsoft® Access® 2010 Programmer's Reference

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison
August 2010
Intermediate to advanced content levelIntermediate to advanced
1272 pages
32h 43m
English
Wrox
Content preview from Microsoft® Access® 2010 Programmer's Reference

Chapter 18. Working with Office 2010

WHAT'S IN THIS CHAPTER?

  • Using Outlook objects in Access using VBA

  • Creating and sending e-mail with Outlook

  • Creating Calendar items in Outlook

  • Using Excel objects in Access using VBA

  • Getting data from an Excel spreadsheet

  • Sending Access data to an Excel spreadsheet

  • Using Word objects in Access using VBA

  • Creating Word documents

  • Sending Access data to Word documents

  • Creating automated mail merges using Word

One of the most powerful features of the Microsoft Office 2010 suite is the interoperability between the various applications. So far, most of the material covered in this book has worked directly within Access and with the Object Model (OM) it provides, but VBA is not specific to Access only. Many of the other Office applications, such as Word, Outlook, and Excel, support VBA and all have their own Object Models that provide the ability to work directly with their respective objects. More importantly, this interoperability provides Access developers with the ability to leverage those Office applications and their features directly from within an Access database application. Similarly, the reverse is true for a developer of Excel spreadsheets; Access features and database data can be used directly from within an Excel spreadsheet application. The idea is that all the features of the entire Office suite of products can be used within any of those products with just a few simple lines of VBA code. This chapter covers the basics of working with the Outlook, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Professional Access 2013 Programming

Professional Access 2013 Programming

Teresa Hennig, Ben Clothier, George Hepworth, Dagi Yudovich

Publisher Resources

ISBN: 9780470591666Purchase book