Re: Export to csv then import into Outlook Calendar

I am trying to accomplish something similar to the original post. The difference being multiple tabs are needed to represent different departments.

Is it possible to code cells in an excel spreadsheet so that they mimic the dates on an outlook calender?

> On Tuesday, November 04, 2008 2:12 PM sjb34 wrote:

> I inpute a yearly shift schedule from paper into an Excel spreadsheet format.
> I would like to know if it is possible to convert an Excel file into the
> Outlook Calendar. I have tried many times but failed miserably. Basically
> we are scheduling 4 operators plus relief for a period of one year. It would
> be much more useful if theis file was in the Outlook Calendar format.
> However presently I would have to input all the information by hand for these
> 4 operators every year. Is there abetter way?
> --
> well at least I was well intended!


>> On Thursday, November 06, 2008 12:04 AM Diane Poremsky [MVP] wrote:

>> What happens when you try? Did you name the range? Map the fields for
>> import?
>> See http://www.slipstick.com/Tutorials/import/import.htm to get an idea of
>> what you need to do.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> Outlook Tips by email:
>> dailytips-subscribe-(E-Mail Removed)
>>
>> EMO - a weekly newsletter about Outlook and Exchange:
>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>>
>> You can access this newsgroup by visiting
>> http://www.microsoft.com/office/comm...s/default.mspx or point your
>> newsreader to msnews.microsoft.com.
>>
>>
>> "sjb344" <(E-Mail Removed)> wrote in message
>> news:FF656ED3-074D-40FC-A5E7-(E-Mail Removed)...


>>> On Friday, February 13, 2009 7:21 PM A. Harney wrote:

>>> Export your excel file to CSV (comma separted values), then import the file into MS Outlook Calendar.
>>>
>>> The only shortcoming may be the date range required. That is what I am working on!!
>>>
>>> HTH,
>>> Ann


>>> Submitted via EggHeadCafe
>>> ASP.NET Drawing a chart using OWC11 - Office Web Components
>>> http://www.eggheadcafe.com/tutorials...omponents.aspx