Create macro in Outlook 2007

  • Thread starter Thread starter Brandon
  • Start date Start date
B

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
 
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:
 
Can you give me some advice on where I could find any code samples to have a
place to start?
 
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:
 
Back
Top