View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KurtB KurtB is offline
external usenet poster
 
Posts: 11
Default Excel to Outlook Calendar Macro

I have a basic list of events, dates, times, and notes in excel. I
would like to run a macro to get this into outlook.
Right now I have
Column A - Subject
Column B - Date
Column C - Time
Column D - Notes (body)

I have about 37 entries and regularly add to this.
I have a few spreadsheets set up in this manner and would like them to
go to different calendars (ie one spreadsheet goes to the calendar
named Investigation, the other to personal). I have seen several
examples in this group but got nothing to work. Many seemed to have
preset appointment data in them.

Thank for the help.