Auto reminders

[Guest]

Hi,

I would like to program reminders in my calendar automatically. My events
and dates (optionally with times) are available in .xls form (or .csv form).
From that form how do I "import" them all into calendar automatically.

Default time of 08.00 am can be set for the reminders.

Alternately, if reminders can be set with date and time then that would be
ideal.

All input welcome.

 

[Michael Bauer [MVP - Outlook]]

Am Tue, 1 Aug 2006 07:49:02 -0700 schrieb DKS:

After you read and parse the file´s content you can create an
AppointmentItem for each reminder with CreateItem(olAppointmentItem).

Set its Start property, and set ReminderMinutesBeforeStart = 0 and
ReminderSet = True.

 

[Guest]

Thanks Michael, this works.

Now that first hurdle is passed, here is the next hurdle. I would like to
provide this macro to other users in my company, together with the file with
the appointments. How can I do that? how can I export my macro and allow
others to import it?

Maybe an add-in or some other means?

Many thanks for all help.

 

[Michael Bauer [MVP - Outlook]]

Am Wed, 2 Aug 2006 05:44:02 -0700 schrieb DKS:

Yes, you can develop an Add-In with VB6 or an Office Developer Edition. Or
you can go to each computer and import the VBA project files manually.

 

[Guest]

Thanks.

Am Wed, 2 Aug 2006 05:44:02 -0700 schrieb DKS:

Yes, you can develop an Add-In with VB6 or an Office Developer Edition. Or
you can go to each computer and import the VBA project files manually.