Checkbox Private

  • Thread starter Frank Van Eygen
  • Start date Views 1,195
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.
Top