Creating Calendar appointments

Hello Ladies & Gents,

I have a few macros that I use to report my work activities with emails. In
a few cases, I note that I have only taken partial action on the task, and
will be completing the task at a later date. In these cases, I create the
CompDate by adding 7 to the Date, then report that date in the email
(CompDate = Date + 7). What I would like to do is to use that CompDate to
set up an Appointment in the Outlook Calendar with the following items using
Outlook 97;
Subject,
Location,
Start time to be CompDate at 1:00 pm,
Reminder set at 0 minutes, and
Categories = "Complete Task"
I tried updating some code which creates an email in Outlook, but I cannot
manage to create the appointment. Can someone please give me some pointers
to help me out?


Any help would be greatly appreciated.

Andrew

Hi Andrew


**** Kusleika's old site
http://www.*****-clicks.com/excel/olAutomating.htm
has good code for this.

HTH. Best wishes Harald


"Andrew" <[email protected]> skrev i melding
news:[email protected]...
> Hello Ladies & Gents,
>
> I have a few macros that I use to report my work activities with emails.
In
> a few cases, I note that I have only taken partial action on the task, and
> will be completing the task at a later date. In these cases, I create the
> CompDate by adding 7 to the Date, then report that date in the email
> (CompDate = Date + 7). What I would like to do is to use that CompDate to
> set up an Appointment in the Outlook Calendar with the following items
using
> Outlook 97;
> Subject,
> Location,
> Start time to be CompDate at 1:00 pm,
> Reminder set at 0 minutes, and
> Categories = "Complete Task"
> I tried updating some code which creates an email in Outlook, but I cannot
> manage to create the appointment. Can someone please give me some
pointers
> to help me out?
>
>
> Any help would be greatly appreciated.
>
> Andrew
>
>

Hello Harald,

Thanks for the link. I've checked it out, and it all seems very good.

Thanks once again

Andrew


Harald Staff wrote in message ...
Hi Andrew


**** Kusleika's old site
http://www.*****-clicks.com/excel/olAutomating.htm
has good code for this.

HTH. Best wishes Harald


"Andrew" <[email protected]> skrev i melding
news:[email protected]...
> Hello Ladies & Gents,
>
> I have a few macros that I use to report my work activities with emails.
In
> a few cases, I note that I have only taken partial action on the task, and
> will be completing the task at a later date. In these cases, I create the
> CompDate by adding 7 to the Date, then report that date in the email
> (CompDate = Date + 7). What I would like to do is to use that CompDate to
> set up an Appointment in the Outlook Calendar with the following items
using
> Outlook 97;
> Subject,
> Location,
> Start time to be CompDate at 1:00 pm,
> Reminder set at 0 minutes, and
> Categories = "Complete Task"
> I tried updating some code which creates an email in Outlook, but I cannot
> manage to create the appointment. Can someone please give me some
pointers
> to help me out?
>
>
> Any help would be greatly appreciated.
>
> Andrew
>
>