In the simplest of terms, I’m attempting to to eat an elephant in my opinion.
I am trying to have the office schedule feed to the oulook accounts that are set up for the office. The schedule is done in Excel, which I have fed in to a “breakdown” of the daily duties. This has been the easy part leading to my main question. What would the programming look like in VBA for Outlook for a macro that would 1) automatically import the information from the “breakdown” MS Excel 97-03 Spreadsheet in to the calendar of outlook & 2) delete any existing “events” in the calendar for the same day (not all events for the day, just events with the same subject/name as what is being imported).
Everything is working (except the deleting part mentioned above) by manually importing the information, but trying to teach the office how to import and having them do this any time a schedule change is made would be next to madness. Can anyone help with this?
