$9.95 – $16.95
“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.
Includes ready to use code.
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.
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.
Just like Working with Word and Working with Excel, Working with Outlook covers a decade of Microsoft Office – from Office 2010 through Office 2007, Office 2003 and Office XP in the one ebook.
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.
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.