|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
December 5th 06, 08:52 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlook Macro problem
Hi
I need to set a large number of Outlook calendar appointments to: Show Time as: Free, and Sensitivity: Private I am having difficulty working out how to write a macro to do this, although I'm sure there must be a way. Can anyone help please? Thanks V 
|
| Ads |
|
#2
December 6th 06, 06:10 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Macro problem
dim obj as object dim appt as Outlook.AppointmentItem dim Folder as Outlook.Mapifolder Set Folder=Application.Session.Pickfolder If not Folder is Nothing Then for each obj in Folder.Items If TypeOf obj is Outlook.AppointmentItem then with appt .BusyStatus=0 .Sensitivity=olPrivate .Save End with Endif Next Endif -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Am Tue, 5 Dec 2006 20:52:38 -0000 schrieb Victor Delta: Hi I need to set a large number of Outlook calendar appointments to: Show Time as: Free, and Sensitivity: Private I am having difficulty working out how to write a macro to do this, although I'm sure there must be a way. Can anyone help please? Thanks V
|
|
#3
December 9th 06, 06:12 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Macro problem
"Michael Bauer [MVP - Outlook]" wrote in message .. . dim obj as object dim appt as Outlook.AppointmentItem dim Folder as Outlook.Mapifolder Set Folder=Application.Session.Pickfolder If not Folder is Nothing Then for each obj in Folder.Items If TypeOf obj is Outlook.AppointmentItem then with appt .BusyStatus=0 .Sensitivity=olPrivate .Save End with Endif Next Endif -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Many thanks, I'll give it a go. V
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook Macro - help please | [email protected] | Outlook - General Queries | 0 | November 29th 06 11:22 AM |
| Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 06:26 AM |
| Macro Problem | Guy | Outlook and VBA | 4 | May 18th 06 04:08 AM |
| VB and outlook macro need help | jbullington | Outlook and VBA | 1 | January 10th 06 03:22 PM |
Linear Mode
