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


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

HTH. Best wishes Harald


"Andrew" skrev i melding
...
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


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

HTH. Best wishes Harald


"Andrew" skrev i melding
...
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