Link and synchronize Access with Outlook

  • Thread starter Thread starter Rob M
  • Start date Start date
R

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
 
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
 
Back
Top