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

Sue Mosher [MVP]

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

Frank Van Eygen

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.
Thread starter Similar threads Forum Replies Date
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 Outlook 2010 Tracking 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
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 New Slipstick.com Articles 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
L Allow private fields Outlook Wishlist 0
K Private meetings do no show in meeting scheduling Using Outlook 2
J Printing Private Appointment Detail on Calendar Printing Assistance Calendar Printing Assistant 0
J Printing Private Appointments on Caledar Printing Assistance Calendar Printing Assistant 2
S how do I set up shared calendar so some can see private details and others can not? Using Outlook 2
D How to push a second outlook 2007 'private' calendar on exchange 2007 to my mobile phone. Using Outlook 1
S exchange 2010 in private cloud Exchange Server Administration 5
H Private Calendar Entries Using Outlook 1
J Coexist Private SAN certificate with 3rd party verisign certificate together in same Exchange 2010 C Exchange Server Administration 6
S How do I mark an email I want to send as 'private'? Using Outlook 2
C Re: Outlook 2010 - Shared Calendar sets all items as private. Using Outlook 3
U 'private' email not private Using Outlook 0
U 'private' email Using Outlook 1
N sending out messages marked private Using Outlook 3
L Prevent Users From Creating Private Appointments on Shared Calendars Using Outlook 3
G How can I delete a private appointment in shared calendar in public folders? Using Outlook 1
A Calendar items are being changed to a private event after I input them into my calendar. Using Outlook 2
A OWA Authentication: Public session vs. Private session Using Outlook 25
B Private Appts. in Outlook 2007 Calendar Sharing Using Outlook 2
T keeping my emails private Using Outlook 1
C Can you disable the OWA login public/private option? Using Outlook 3
A Calendar private appointments, an unresolved question... Outlook VBA and Custom Forms 3
Similar threads


















































Top