Create macro in Outlook 2007

[Brandon]

I would like to create a macro under a button in Outlook 2007 so I can select
an appointment in my calendar, then have the macro do these things to the
selected appointment: 1) Show the time as "free", 2) Set reminder to "None",
3) Categorize as "Personal", and 4) Make Private.

Would someone please post the VBA code I would need to use to accomplish
this task?

Thanks in advance,
Brandon

 

[Brandon]

Anyone???

 

[Michael Bauer [MVP - Outlook]]

Usually you get here advices for how to write VBA for Outlook, but you'd
have to write the stuff yourself.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 31 Dec 2008 05:44:00 -0800 schrieb Brandon:

 

[Brandon]

Can you give me some advice on where I could find any code samples to have a
place to start?

 

[Michael Bauer [MVP - Outlook]]

A good place to start with is the VBA help. Open the object browser (f2),
and switch from <All Libraries> to Outlook. In the left pane you see all the
objects; select one, then all of the properties and methods of the selected
object will be listed in the right pane. If you select one item and press
f1, you'll get to the appropriate page of the help file. Most of the stuff
comes with a VBA sample.

For your requirement, you can't select (in the meaning of highlighting) an
appointment by code. Application.ActiveExplorer.Selection.item(1) gives you
the first selected item (if one was manually selected).

The property names for the rest are: BusyStatus, ReminderSet, Categories,
and Sensitivity.

Eventually, call the Item's Save method.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Wed, 31 Dec 2008 09:17:01 -0800 schrieb Brandon: