“Using Outlook and Access together for great results”
Helen Feddema, editor of Access Watch, shows you how to exchange data between Access and Outlook.
From an Access database, you can make email messages, create contacts, tasks or appointments.
Or import Outlook information into Access to manipulate in ways that Outlook can’t do.
Access is a great database, ideal for storing data that you can add and edit in forms and display in reports. And Outlook has great Calendar, Task List, and of course Email features. In fact Outlook is a database too … a big, complex database but still a database.
Helen shows how get the two Office programs to ‘play nice’.
Maybe you need to send emails to customers on a certain date stored in an Access table, or create appointments in an Outlook calendar, or store data from incoming emails in an Access table?
Rather than try to recreate the Outlook Calendar or Contacts in Access, you can use VBA code to easily transfer data between Access and Outlook, allowing you to use the best features of each application.
When exporting data from Access to Outlook, you have a choice of creating standard or custom Outlook items (mail messages, appointments, tasks or contacts), with data placed in the body of the item, or attached as a file to a mail message. You can also send emails to all members of a distribution list.
You can import data from standard and custom Outlook mail messages, and from .csv files attached to mail messages, from standard and custom contacts, or from standard tasks or appointments.
The ebook also discusses the use of controls on the main menu to store various paths for use in code, using database properties, and gives many useful tips on debugging your VBA code.
The ebook comes with detailed examples of all the export and import techniques, sample databases in both .mdb (Access 2002/2003) and .accdb (Access 2007/2010) formats, and two Outlook templates (.oft files) and one sample message (.msg file) for importing.
Not theory … working code
Rather than talk about how Access and Outlook should work, Helen shows how they do work with real code and forms you can use.
Included in Working with Outlook is complete code (for Office 2010, 2007, 2003 and XP) with forms that you can easily adapt to your own needs.
One book … many versions
This is important because many businesses have a mix of Office versions.
Both MDB and ACCDB versions of the sample code are provided with version variations clearly marked in the ebook itself.
Access debugging help from an expert
Debugging Access code can be more of an art than a science … so Helen Feddema has a whole chapter devoted tips, tricks and workarounds to help you get your code working.
- Five ways to get data from Access to Outlook, depending on your need.
- Seven ways to get data from Outlook to Access, depending on your need.
- Sample code for each method
- Code and details for Access & Excel 2002 (XP) through Access & Excel 2010
- Design techniques for a more useful and attractive main menu for any Access database
- Access debugging tips from an expert
- Over 85 pages of original content. PDF format
Access Archon: Working with Outlook
- Office 2013 – Access 2013, Outlook 2013
- Office 2010 – Access 2010, Outlook 2010
- Office 2007 – Access 2007, Outlook 2007
- Office 2003 – Access 2003, Outlook 2003