On completion of a task, can I email a copy of the task to myself

G

Guest

When I mark a task as completed, I would like a VBA macro to automatically
send an email to me with the details of the task. Is there existing code
that can do this, or can someone help me figure out how?

I would like to customize the subject of the email with the start and end
dates of the completed task.

Thanks,
Richard
 
M

Michael Bauer [MVP - Outlook]

The ItemChange event of the task folder tells you when an item changes, see
the sample in the VBA help file.

In that event you can check the item's Status property. If it's
olTaskCompleted then create an email with the Createitem function, add your
address via Recipients.Add and write in the subject and body property
whatever you want, e.g. the values of the TaskItem's StartDate and EndDate
properties.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize Outlook email:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 14 Jun 2007 08:12:01 -0700 schrieb Richard T:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top