Importing Schedule into Outlook from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently, our schedules are available on the internet and can be exported
into excel. Is there a way to run a macro from excel that would create the
schedule in outlook calendar. As our schedules are constantly changing, is
there a way to remove selected old items or rwould it be best to create a new
folder in Outlook calendar to import these items to, that can be deleted and
recreated with every import? Would it be best to take the date from excel
and run a macro in excel to format it for notepad, copy it into notepad and
then save as a .ics or .vcs file and import? So far I have been able to call
outlook and create a new calendar folder, but have had trouble getting the
data into the folder.
 
Try the Import and Export command from the File menu and select Excel as the
output format. Take a look at how it's formatted - if you can make your
changes to this sheet (keeping the column names intact) you could easily
import it back in using the Import and Export command as well.

Of course this doesn't give you control over removing unwanted appointments
but it's a start. For more advanced processing you'll need to use VBA to
parse the Excel data and create the appointments in Outlook or edit/delete
existing ones.

There's also a sample here that may already do what you want:

OutlookCode.com :: Outlook Code Samples :: Basic Outlook :: Import
Appointments FROM Excel:
http://www.outlookcode.com/codedetail.aspx?id=788
 
Back
Top