Thanks David, the solutions you provided are great. But I think I need something much simpler but I am not sure how to start working on it. The story is that I am developing a database for a client who wants to have a filed that is named "next action" which could be sending a birthday wishes, inviting for a meeting, or .... etc. My client who is the user of the database wants to have this "next action" automated so that it goes directly to his outlook as a task to remind him 1 or 2 days before the birthday date for example or the meeting date.
I think I have to add a field next to the "next action" field and make it the "data" field which will be used for the outlook task.
Now my problem is what is the best way to to do this in an easy way to be used by my client.
I would appreciate any ideas for this.
Thanks!
Marwa
--- In MS_Access_Professionals@yahoogroups.com, "David Powell" <david@...> wrote:
>
> 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