Excel to Outlook Link

**ninja0059** · 09-24-2008, 01:18 PM

I am trying to build a macro (or something else) that will look at an MS Outlook calendar and populate the data in an MS Excel spreadsheet.

Can this be done?

**mrice** · 09-24-2008, 03:02 PM

Yes it can. However, you might be better looking at the export functionality in Outlook in the first instance.

**ninja0059** · 10-24-2008, 11:09 AM

Can you provide me with the code or formula that would allow me to do this. Also, I am trying to have a live link to outlook rather than having to export/import the data on a daily basis..

Thanks