Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Can I automatically make appointments into tasks also? (http://www.outlookbanter.com/outlook-vba/8828-can-i-automatically-make-appointments.html)

Duncan McC March 20th 06 09:39 AM

Can I automatically make appointments into tasks also?
 
A guy posted a Q in the .calendaring NG (see below) - and I'm wondering
now if it can indeed be done (fire off the Save Event - if such a thing
exists)...

Subject: Can I automatically make appointments into tasks also?
From: Duncan McC
Newsgroups: microsoft.public.outlook.calendaring
Date: Thu, 16 Mar 2006 21:32:49 +1300

In article ,
says...
I want to have my appointments automatically become a task when I create
them. What I'd really like is to have appointments that contain certain words
("School" or "Call") be saved as both a task and an appointment. I'm
constantly having to drag and drop right now, I'd really like to see if there
is a better way. Thank you.


You could use a wee macro to do this for you - the following macro will
turn the appointment you are on (saved) into a Task...

Sub CreateTaskFromAppointment()
Dim objCurrentItem As Outlook.AppointmentItem
Dim objNewTaskItem As Outlook.TaskItem

Set objCurrentItem = Application.ActiveInspector.CurrentItem
Set objNewTaskItem = Outlook.CreateItem(olTaskItem)

objNewTaskItem.Subject = objCurrentItem.Subject
' set more properties...

objNewTaskItem.Save

Set objCurrentItem = Nothing
Set objNewTaskItem = Nothing

End Sub

--
Duncan


[one of his replies, and mine to that]...

Subject: Can I automatically make appointments into tasks also?
From: Duncan McC
Newsgroups: microsoft.public.outlook.calendaring
Date: Sat, 18 Mar 2006 13:25:58 +1300

In article ,
says...
Hey Duncan, before I start screwing stuff up trying to create the macro, I
had a few more questions. Is this going to be automatic (create the task when
I click "save and close" a new appointment), or will I need to go in to
macros and run it each time? My second one is a bit trickier, can I have new
tasks created from a new appointment ONLY if I have assigned it a specific
label (the color coding)? For example, create both the appointment and the
task when I select a red label, but just create the appointment when I select
a purple one. Thanks again


I think that can all be coded up - but I'm no expert.

Not sure on triggering off the Save button though (could surely make a
new button that does the same (Save, *and* put in Tasks IF color is set,
etc).

I would post to the vba NG - microsoft.public.outlook.program.vba - and
see if the experts can help you there.

--
Duncan

So yeah... can this be done? Is there an Event triggered on "Save"? If
not, best other options?

--
Duncan

Ken Slovak - [MVP - Outlook] March 20th 06 05:07 PM

Can I automatically make appointments into tasks also?
 
If you want to save an item you created using code you call the item's Save
method.

--
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


"Duncan McC" wrote in message
...
A guy posted a Q in the .calendaring NG (see below) - and I'm wondering
now if it can indeed be done (fire off the Save Event - if such a thing
exists)...

Subject: Can I automatically make appointments into tasks also?
From: Duncan McC
Newsgroups: microsoft.public.outlook.calendaring
Date: Thu, 16 Mar 2006 21:32:49 +1300

In article ,
says...
I want to have my appointments automatically become a task when I create
them. What I'd really like is to have appointments that contain certain
words
("School" or "Call") be saved as both a task and an appointment. I'm
constantly having to drag and drop right now, I'd really like to see if
there
is a better way. Thank you.


You could use a wee macro to do this for you - the following macro will
turn the appointment you are on (saved) into a Task...

Sub CreateTaskFromAppointment()
Dim objCurrentItem As Outlook.AppointmentItem
Dim objNewTaskItem As Outlook.TaskItem

Set objCurrentItem = Application.ActiveInspector.CurrentItem
Set objNewTaskItem = Outlook.CreateItem(olTaskItem)

objNewTaskItem.Subject = objCurrentItem.Subject
' set more properties...

objNewTaskItem.Save

Set objCurrentItem = Nothing
Set objNewTaskItem = Nothing

End Sub

--
Duncan


[one of his replies, and mine to that]...

Subject: Can I automatically make appointments into tasks also?
From: Duncan McC
Newsgroups: microsoft.public.outlook.calendaring
Date: Sat, 18 Mar 2006 13:25:58 +1300

In article ,
says...
Hey Duncan, before I start screwing stuff up trying to create the macro,
I
had a few more questions. Is this going to be automatic (create the task
when
I click "save and close" a new appointment), or will I need to go in to
macros and run it each time? My second one is a bit trickier, can I have
new
tasks created from a new appointment ONLY if I have assigned it a
specific
label (the color coding)? For example, create both the appointment and
the
task when I select a red label, but just create the appointment when I
select
a purple one. Thanks again


I think that can all be coded up - but I'm no expert.

Not sure on triggering off the Save button though (could surely make a
new button that does the same (Save, *and* put in Tasks IF color is set,
etc).

I would post to the vba NG - microsoft.public.outlook.program.vba - and
see if the experts can help you there.

--
Duncan

So yeah... can this be done? Is there an Event triggered on "Save"? If
not, best other options?

--
Duncan



Duncan McC March 21st 06 11:11 PM

Can I automatically make appointments into tasks also?
 
In article ,
says...
If you want to save an item you created using code you call the item's Save
method.


I would like to trigger the code, based on the Save action (keyboard or
mouse) - is this possible?

--
Duncan

Ken Slovak - [MVP - Outlook] March 22nd 06 03:16 PM

Can I automatically make appointments into tasks also?
 
Handle the Item.Save event then.

--
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


"Duncan McC" wrote in message
...
In article ,
says...
If you want to save an item you created using code you call the item's
Save
method.


I would like to trigger the code, based on the Save action (keyboard or
mouse) - is this possible?

--
Duncan



Ken Slovak - [MVP - Outlook] March 22nd 06 03:18 PM

Can I automatically make appointments into tasks also?
 
My bad. Make that the Item.Write event.

--
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


"Ken Slovak - [MVP - Outlook]" wrote in message
...
Handle the Item.Save event then.

--
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



Duncan McC March 23rd 06 01:21 AM

Can I automatically make appointments into tasks also?
 
In article ,
says...
My bad. Make that the Item.Write event.


Thanks Ken, looking into it.

--
Duncan


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com