Access to Outlook task

[bustersports]

I have an Access database I wrote for facilitating meeting. I am looking for a way to send to an attendee a task that lists the details on the item they have plus the due date. Example: If John Doe has to complete task A by Nov 11, I would like to send to their Outlook a task item to complete it.
Anyone have any suggestions. Thanks in advance for your help.
David

 

[PHV]

Have you tried to link an access table to the outlook tasks folder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bustersports]

I did not try to link an access table to the Outlook tasks folder. I want to be able to send the task to anyone who should see it, not just post to my Outlook.

Thanks,
David

 

[gol4]

heres some code to get you started

Function fncAddOutlookTask()
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem

Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)

With OutlookTask
.Assign
.Subject = "This task came from access"
.Body = "details would go here"
.ReminderSet = False
.Recipients.Add ("receptname@domain")
.duedate = #11/5/2004#
.Send
.Save
End With
End Function

 

[bustersports]

gol4

Thanks for the response. However, I receive an error when doing the compile - "User-defined type not defined". Is something missing?
Thanks,
David

 

[PHV]

You have to reference the Micrososoft Outlook object library:
while in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bustersports]

PHV

Thanks very much.

 

[data1025]

I hope this message relates enough to the topic..

Does anyone know the names of the Created, Modified, and Date Complete fields? I am using access to pull data from Outlook, and most of the fields are working, but the date fields I cannot find the correct itm names.

I have tried several variations of itm.xxxxxx and cannot find the right ones.

Is there a complete list anywhere?

Thanks,
Eric

 

[PHV]

Here some properties of the TaskItem object:
CreationTime, DateCompleted, DueDate, LastModificationTime
You may have to check the IsRecurring one ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244