I would like to develop a way to export Access results to Outlook's Calendar or Tasks. For example if a client is due a follow up appointment in 6 weeks, I want to send a tickler from Access to Outlook so it will remind the Outlook user.

The SendObject macro step will send an email, but I want to populate the calendar or task list for the specific date instead.

Outlook seems to be the only Office package the staff keeps open on a regular basis and we need to keep client records private, so keeping Access open all the time to track reminders is not a suitable option.

Any thoughts or ideas?