Checkbox Private

Status
Not open for further replies.
F

Frank Van Eygen

I have a macro in Excel that generates a calendar appointment in Outlook that

works fine except that I don't know how to set the Private checkbox in

Outlook.

Can somebody help please?
 
The object browser (F2 in VBA) is your friend. Take a look at the

AppointmentItem.Sensitivity property.

Sue Mosher

"Frank Van Eygen" <FrankVanEygen> wrote in message

news:5799C676-ED42-4ADB-9365-841B0D80D1F2@microsoft.com...
> I have a macro in Excel that generates a calendar appointment in Outlook
> that
> works fine except that I don't know how to set the Private checkbox in
> Outlook.
> Can somebody help please?
>
 
Tahnk you Sue,

This did the trick:

Set olApt = olApp.CreateItem(olAppointmentItem)

olApt.Sensitivity = olPrivate

"Sue Mosher [MVP]" wrote:


> The object browser (F2 in VBA) is your friend. Take a look at the
> AppointmentItem.Sensitivity property.
> > Sue Mosher
> > >

> "Frank Van Eygen" <FrankVanEygen> wrote in message
> news:5799C676-ED42-4ADB-9365-841B0D80D1F2@microsoft.com...
> >I have a macro in Excel that generates a calendar appointment in Outlook
> >that
> > works fine except that I don't know how to set the Private checkbox in
> > Outlook.
> > Can somebody help please?
> >

> .
>
 
Status
Not open for further replies.
< how to configure different contact default form for new contacts | VBA about sending e-mail automatickly >
Similar threads
Thread starter Title Forum Replies Date
V Why is "Value Required" checkbox greyed out for Dates? Outlook VBA and Custom Forms 2
J Program Checkbox that will activate a text box in a Outlook fallible form. Outlook VBA and Custom Forms 1
A Greyed out checkbox in custom form Outlook VBA and Custom Forms 4
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
Stephen Weinberg Changing the mailing address checkbox Using Outlook 0
S Open custom meeting request with checkbox Using Outlook 0
S Outlook custom checkbox not changing value Using Outlook 0
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
T Ribbon and a checkbox (C++ ATL) Outlook VBA and Custom Forms 8
J Checkbox Outlook VBA and Custom Forms 1
C Boolean values for Checkbox fields Outlook VBA and Custom Forms 1
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 4
A Cannot copy this folder because it may contain private items Using Outlook 0
N Private check box in table view Using Outlook 0
Diane Poremsky How to Easily Change the Private Flag Using Outlook 0
A Customize meeting form. Private notices Outlook VBA and Custom Forms 3
D Shared Mailbox with mail item marked as "private" Using Outlook 0
O Add private notes or comments to Outlook meeting invite Using Outlook 4
L Showing @live account in outlook 2013 calendar as private appointment Using Outlook 1
R Default Start time for Private Appointment Using Outlook 4
N Outlook Shared appointments automatically to Private Calendar Using Outlook 1
Britonius Delegate cannot view meetings marked Private by Another Chairperson Using Outlook 7
W Outlook 2010 - Displaying Private Appointments In Shared Calendars Using Outlook 1
R Private Sub Application_ItemSend() -Cannot make this code work in Outlook 2013 Using Outlook 0
G Private Address Groups Using Outlook 0
K Private Calendar events Using Outlook 3
M Auto-color all Calendar items based on condition: Private Using Outlook 6
D Private messages not forwarding by rule? Outlook 2007 Using Outlook 1
M Can't mark appointments as private for other user Using Outlook 1
K Private meetings do no show in meeting scheduling Using Outlook 2
J Printing Private Appointment Detail on Calendar Printing Assistance Using Outlook 0
J Printing Private Appointments on Caledar Printing Assistance Using Outlook 2
A Calendar private appointments, an unresolved question... Outlook VBA and Custom Forms 3
R auto-copy from private to public folder Outlook VBA and Custom Forms 3
D Automark incoming appointment request as private Using Outlook 3

Similar threads

Back
Top