Ask a new question

Publish an excel roster to outlook calendar

I produce a staff roster in excel (office 2007) & I want to publish this roster in the outlook calendar so staff can view their roster online any suggestions
Answer
Answer

In order to import calendar data in Outlook, you will format the excel file in certain format prior importing.

 

To get an example format, you can first export some entries from Outlook to Excel. Then use that format, include new entries and import in Outlook.

 

To export from Outlook to Excel:

File > Import and Export > Export to file > Next > Microsoft Excel > Select Calendar > Specify filename > Finish > Specify date range

 

To import from Excel to Outlook:

http://www1.towson.edu/adminfinance/ots/training/documents/Outlook_2003_Importing_Calendar_Data.pdf

Like to answer questions which aren't answered for long time.

Excelee.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 5, 2024 Views 3,662 Applies to: