Outlook and Access integration using VBA


Rhys Davies

Hi there, in our access database i have code that allows a user to create an
outlook appointment, which can be seen below:

Dim objOutlook As Object
Dim objItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objItem = objOutlook.CreateItem(olAppointmentItem)
With objItem
.Subject = Title & " " & ": Appointment"
End With
Set objOutlook = Nothing

however, what would be really useful is if it could go one step further and
open existing calendar items rather thana new item. we have a section on the
access database where users enter activity i.e. work done with a client on a
particular date - it would be really nice if when the user selects a date on
this activity screen that they could also maybe hit a command button that
would open up their outlook calendar on the same date as the date selected
within access itself so they can quicky copy and paste some of the
information that they have previosuly entered in their calendar into their
activity. or even that hitting the button opens up an access form that holds
information from the relevant fields from their outlook calendar - i have
seen this done and have done it myself but the opposite way i.e. you write it
into outlook. unfortunately this now doesnt work for us because we do our
activity retrospectively.

any help would be greatly appreciated

Michael Bauer [MVP - Outlook]

In Outlook 2007 the Explorer supports the CurrentView property, whcih
returns a CalendarView object if the current folder is a calendar. And the
CalendarView supports the GotoDate function.

Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:

Am Thu, 25 Mar 2010 06:36:01 -0700 schrieb Rhys Davies:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question