Tassk from access to Outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chad - 01 Jul 2004 04:16 GMT

Is there a way to push a task from access to Outlook and
set the time, frequency, subject, message, and to email
address?

Something like:

Dim objOutlook As Object
Dim objOutlookMsg As Object
Dim objOutlookRecip As Object
Dim objSentFolder As Object
Dim myNamespace As NameSpace
Dim myTaskItems As Object

Set objOutlook = CreateObject("Outlook.Application")
Set myNamespace = objOutlook.GetNamespace("MAPI")
Set mytask = myNamespace.GetDefaultFolder(olFolderTasks)
Set mytask = mytask.Parent.Folders.Add
("IPM.Task.myTask") 'This is not inserting a task - only
a folder named "IPM.Task.myTask"

Need the SendToAddress
Need to populate the Subject field
Need to populate the Message field
Need to set to email daily at a certain time

Thanks
Chad

Reply to this Message

Ken Slovak - [MVP - Outlook] - 01 Jul 2004 15:56 GMT

Tasks don't get emailed unless you assign them to someone or you attach the
task or its text to an email. You have to code that separately.

Create a task by adding an item to a Tasks folder and then set the
MessageClass of the task item to what you want. Then set all your standard
and user-defined task fields.
Set mytaskfolder = myNamespace.GetDefaultFolder(olFolderTasks)
Set mytask = mytaskfolder.Items.Add
mytask.MessageClass = ("IPM.Task.myTask"

Use the Object Browser to see what properties are available for Task items
and how they are named and used.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

> Is there a way to push a task from access to Outlook and
> set the time, frequency, subject, message, and to email
[quoted text clipped - 23 lines]
> Thanks
> Chad

Reply to this Message

Mark B - 05 Jul 2004 03:15 GMT

One option you may want to know about is that you could interface with the
Task Manager 2005 backend MDB since it is an Access db.

You could then have Auto-synchronization switched on.

You may be able to do it with an update query in conjunction with Task
Manager 2005.

See
http://office.microsoft.com/marketplace/portalpreview.aspx?AssetID=EM01120212103
3&CTT=1&Origin=EC790000701033&QueryID=zAh5QgVJJ0&Query=orbisoft&Scope=EP%2cEM

> Is there a way to push a task from access to Outlook and
> set the time, frequency, subject, message, and to email
[quoted text clipped - 23 lines]
> Thanks
> Chad

Reply to this Message