Automating Outlook with Excel

**mppotter** · 09-04-2011, 12:40 AM

I am a newbie at vba and was wondering if only one could help me? I am trying to automate outlook to export appointments into a spreadsheet. I have look for several weeks for at least some starter code but have had no luck. Please help!

**Kenneth Hobson** · 09-04-2011, 01:45 AM

Welcome to the forum! The Outlook MVP websites would be the first that I would look into. http://www.mvps.org/links.html#Outlook

**gjlindn** · 09-04-2011, 02:15 AM

Here's a sample to get you started. You need to add a reference to Outlook 2010 if you haven't already done so.

Please Login or Register  to view this content.

**mppotter** · 09-05-2011, 10:44 AM

Thanks for that! I've tried the outlook.application, but I think because it's outlook '03 it doesn't recognize it. It gives me a compile error: user-defined type not defined. Any thoughts or work arounds for this?

**snb** · 09-05-2011, 11:08 AM

Keep it simple

Please Login or Register  to view this content.

**jaslake** · 09-05-2011, 11:16 AM

Hi mppotter

The code provided uses early binding (look it up). With the code you need to set a reference to the Microsoft Outlook Object Library as stated by gjlindn.

Alt F11 -> Tools -> References -> Microsoft Outlook Object Library (whatever version)