Chapter 16. Integrating Outlook

Because Access 2010 is part of the Office suite of applications, it has been designed to be easily integrated with the other Office applications. In this chapter, you'll see how you can use Outlook to send e-mails from your Access solution. You can also use Access and Outlook together to create a simple data collection facility.

You'll provide a solution that sends an e-mail to each customer that has an overdue item. I'll show you first how to do this as a data macro. Using a data macro is also a great way to send an e-mail to notify someone when a record is inserted or updated. Using a macro is also the best way to send an e-mail from a web database. I will then show you how to send e-mails using VBA, which gives ...

Get Pro Access 2010 Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.