Results 1 to 1 of 1
2015-08-29, 08:53 #1
- Join Date
- Dec 2011
- Thanked 0 Times in 0 Posts
Use Excel dates to create Outlook calendar items
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!