Hi folks,

We have an Excel spreadsheet with hundreds of events. Each event has a column entry with a date. We want to use each of those dates to create appointments on a group calendar so we have a "tickler" system to remind us when one of these events is upcoming. Is there a way to do this? I'm thinking of something almost like a mail merge where Outlook reads the event name column to populate the appointment title and the date column to populate the appointment date.

I'm not a very good VBA programmer but I dabble so I'm not totally intimidated by the prospect of programming my way out of this.

Thanks in advance for your help!