Create Outlook Task & Reminder from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a form in my service calls db with, amongst other fields, a Target
date field and a check box. What I would like to happen is: when the box is
checked, a single task is created in Outlook with a reminder, say two days in
advance of the Target date. Question is, is this possible and if so how to go
about it? I've seen some code on these discussion groups that seems to cover
it but only for Access/Outlook 2003, whereas I use Access/Outlook 2000.

Any help/advice would be greatly appreciated and i'm fairly new to
programming and code so go easy on me!

Thanks
Martyn

Access 2000
Outllook 2000
Windows 2003 server over Citrix PS
 
I use the following code to make an appointment from Outlook.
You will notice i get the details from a form. Also I have commented out the
fields I do not use.

Private Sub Command16_Click()

Dim olApp As Outlook.Application
Dim olNewMeeting As Outlook.AppointmentItem
Dim Starta As String
Dim Durationa As Integer
Dim Subjecta As String
Dim Bodya As String
Starta = "#" & Me.Adate & " " & Me.ATime & "#"
Durationa = Me.ADuration
Subjecta = Me.AClient & " - " & Me.ASubject
' Bodya = Me.ABody

Set olApp = New Outlook.Application
Set olNewMeeting = olApp.CreateItem(olAppointmentItem)
'MsgBox Starta
With olNewMeeting
' .Recipients.Add "SomePerson"
' .Start = "#" & Me.Adate & " " & Me.ATime & "#"
.start = Me.Adate & " " & Me.ATime
' .Start = #4/15/2004 3:15:00 PM#
.Duration = Me.ADuration
.Importance = olImportanceHigh
.Subject = Subjecta
' .Actions = Bodya
.Save
End With
End Sub
 
Chris

Thanks very much for that. After posting I found an article on MS support
relevant to Access 2000 (http://support.microsoft.com/kb/209932/en-us), but
your example works just as well when I adapted it for a Task Reminder taking
the info directly from my form.

Cheers for your help (and so promptly!)

Martyn
 
Back
Top