While you're waiting for a better answer, my hunch is that you'd use VBA to open a local instance of Outlook, and send a TaskItem to the recipient by email (that's assuming that the required Outlook recipient is remote - I guess it's a bit simpler otherwise).
The remote recipient would receive it as a task request item which they'd accept and hence have added to their task list.
http://msdn.microsoft.com/en-us/library/bb219975%28v=office.12%29.aspx
Here's the 2007 reference for TaskItem:
http://msdn.microsoft.com/en-us/library/bb219972%28v=office.12%29.aspx
It seems to me that the 2003 doc is easier to follow:
http://msdn.microsoft.com/en-us/library/aa211067%28v=office.11%29.aspx
You need to set up an application object variable for Outlook if you're not calling from within Outlook itself. The example in this code appears to be oriented this way. The principle is the same as if you're controlling Excel or Word from Access. There are many examples of the latter around.
It might be as well to add a field you can set when your program has successfully sent its message to Outlook. In the case of failure, you'd be able to retry on a later occasion, or at least identify the failure without stopping the whole show.
Maybe one of the other sites has some prepackaged code.
David
--- In MS_Access_Professionals@yahoogroups.com, "Marwa Abo Amra" <m.statalex@...> wrote:
>
> Hi Friends,
>
> I need to link a field in the database, so that the record in that field is sent to outlook to remind the user to do the task on date that is 1 or 2 days before the due date. How can I do that?
>
> Thanks!
>
> Marwa
>
Tidak ada komentar:
Posting Komentar