Link and synchronize Access with Outlook

[Rob M]

Hi everyone,

I have an access 2003 database with patient information and
appointment dates/times. I would like to link the appointments with
Outlook, specifically so that:

- Appointments created in one program appear in the other.
- Appointments edited/deleted in one program are edited/deleted in the
other.

I know how to link an Outlook table in Access, which works well when
additions/edits/deletions are executed in Outlook. However,
appointments can't be created/edited/deleted from Access because the
linked table does not contain the required fields.

I found a Microsoft example of sending an appointment to Outlook from
Access (http://msdn.microsoft.com/en-us/library/aa159619(office.
11).aspx). However, I don't know of a way to edit that appointment in
Outlook that edits the underlying Access table data.

Can anyone help with this?

Many thanks,
Rob

 

[a a r o n . k e m p f]

if you go to www.freevbcode.com and you search for the keyword
'outlook' then you can find _LOTS_ of examples where people use VB
automation to programmatically create / edit objects

For example
http://freevbcode.com/ShowCode.Asp?ID=159



Public Sub SendOutlookMail(Subject As String, Recipient As _
String, Message As String)

On Error GoTo errorHandler
Dim oLapp As Object
Dim oItem As Object

Set oLapp = CreateObject("Outlook.application")
Set oItem = oLapp.createitem(0)
'
With oItem
.Subject = Subject
.To = Recipient
.body = Message
.Send
End With
'
Set oLapp = Nothing
Set oItem = Nothing
'

Exit Sub

errorHandler:
Set oLapp = Nothing
Set oItem = Nothing
Exit Sub
End Sub