put tasks in outlook without server

[CherylDetrick]

I want to put my project pro 2003 tasks into Outlook, but I'm a single user
and don't have a server. Is it possible?

 

[Rick Williams]

I want to put my project pro 2003 tasks into Outlook, but I'm a single user
and don't have a server. Is it possible?

It's easy - here is a Project macro to do it.

Sub OutlookLink()
'make sure to add a reference to Outlook in Projects VB Editor
Dim appOL As Outlook.Application
Dim mspTask As MSProject.Task
Dim olTask As Outlook.TaskItem
Set appOL = GetObject(, "Outlook.Application")
For Each oTask In ActiveProject.Tasks
Set olTask = appOL.CreateItem(olTaskItem)
'note that you can capture other Project fields into Outlook fields
olTask.Body = mspTask.Name
olTask.DueDate = mspTask.EarlyFinish
olTask.StartDate = mspTask.EarlyStart
olTask.Save
Set olTask = Nothing
Next



End Sub

 

[CherylDetrick]

Hi Rick:

I'm really a rookie -- where and how do I put that macro?

Thanks!

Cheryl

 

[Rick Williams]

Hi, Cheryl!
Go to Tools, Macro, Macros, then type in OutlookLink and click Create. The
VB Editor will come up, with the first and last lines already inserted for
you. Click Tools, References, and check Microsoft Outlook Object Library
(your version number will be in there). Once it is checked, click OK. Then
copy and paste the original macro code (without the Sub and End Sub lines in
between those lines in the VB Editor. Now save, and you're done. Just click
the Run button (looks like a right arrow) to run it. In the future you can
run it from Project by going to Tools, Macro, macros, selecting it from the
list, and click Run.
Write me directly if you have any problems or questions. I hope it works for
you.
Regards,
Rick Williams
(e-mail address removed)