Opening an Outlook task request from an Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,

I would like to have a button on my Form open the request task section of
Outlook, preferably with a default recipent already created. Is this
possible? and if so a BIG hint as to how to do this would be very much
appreciated.

Thanks in advance

Rob

I am using Office 2003
 
Thanks for the quick response, what you've done with the open task button is
almost spot on, I just can't see how you got it to create a new task - some
additional pointers would be very much appreciated.
 
I can't take credit for that MDB, but before you try the code you need to
create reference to Microsoft Outlook.
Open the code , any where, select tools > reference in the menu bar, and add
Microsoft OutLook from the list
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Hi Again,

I tried to use the code but I can't seem to get just the create task option
to work, it seems the way the code is written it requires a group of six
buttons and I can't seem to get around this (As I only need one). Any help
would be appreciated.
 
Try this
Function CreateNewTask()

Dim spObj As Object, objItem As Object

Set spObj = CreateObject("Outlook.Application")

Set objItem = spObj.CreateItem(olTaskItem)
objItem.Display
Set spObj = Nothing

End Function
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Back
Top