Create Appointments Using Spreadsheet Data

Use an Excel macro to create appointments in subcalendars in Outlook. To use, type the appointment data, including the calendar name, into the spreadsheet then run the macro. The macro creates appointments in the correct calendar folder.