Results 1 to 2 of 2
Thread: Access to Outlook (2k)
2002-07-24, 13:44 #1
- Join Date
- Jan 2001
- Kendrick, Idaho, USA
- Thanked 0 Times in 0 Posts
Access to Outlook (2k)
This is still in the contemplation stage. Is it possible for Access to trigger Outlook's calendar or task module? Rather than develop a tickler system as part of an Access system, can Access send date data to Outlook?
2002-07-24, 14:21 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Access to Outlook (2k)
It is possible to control Outlook from Access in VBA.
Open any module.
In the list, look for Microsoft Outlook xx Object Model.
Check the check box and click OK.
From now on, you can use Outlook VBA in this database.
Here is an example of creating a task, getting values like the subject from text boxes on a form:
Dim appOutLook As Outlook.Application
Dim taskOutLook As Outlook.TaskItem
Set appOutLook = CreateObject("Outlook.Application")
Set taskOutLook = appOutLook.CreateItem(olTaskItem)
.Subject = Me.txtSubject
.Body = Me.txtBody
.ReminderSet = True
'Set to reminder time.
.ReminderTime = Me.txtReminder
'Set the due date.
.DueDate = Me.txtDueDate
.ReminderPlaySound = True
'Add the path to a .wav file on your computer.
.ReminderSoundFile = "C:WindowsMediaDing.wav"
Set taskOutLook = Nothing
Set appOutLook = Nothing