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