outlook 2003 macro to extract calendar appointment info to Excel

**CPOjoe** · July 14th 08, 11:03 PM posted to microsoft.public.outlook.calendaring

I need to be able to extract such information as start date/time, stop
date/time, subject and description from calendar appointments and export to
excel. I need to be able to do this at least weekly and, ideally, with the
click of a button.

I feel pretty sure that if I knew VBS, I could do this pretty easily -- but,
alas, I don't.

Any help would be GREATLY appreciated.

**Diane Poremsky {MVP}[_2_]** · July 15th 08, 02:19 AM posted to microsoft.public.outlook.calendaring

if you create a custom view with the fields you need and filter it for the
records you need, you can copy and paste it into Excel. It's a couple of
more steps but works well.

http://www.outlook-tips.net/howto/copy_data.htm has an example.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:

Exchange Messaging Outlook newsletter:

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

"CPOjoe" wrote in message
...
I need to be able to extract such information as start date/time, stop
date/time, subject and description from calendar appointments and export
to
excel. I need to be able to do this at least weekly and, ideally, with
the
click of a button.

I feel pretty sure that if I knew VBS, I could do this pretty easily --
but,
alas, I don't.

Any help would be GREATLY appreciated.

**CPOjoe** · July 15th 08, 03:36 PM posted to microsoft.public.outlook.calendaring

Thanks -- that would work well enough; but, I'm working on this for some
other folks who really want to be able to just "push a button" to get it
done.

So, I'm looking for more of a macro/vbs solution.

Joe

"Diane Poremsky {MVP}" wrote:

if you create a custom view with the fields you need and filter it for the
records you need, you can copy and paste it into Excel. It's a couple of
more steps but works well.

http://www.outlook-tips.net/howto/copy_data.htm has an example.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:

Exchange Messaging Outlook newsletter:

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

"CPOjoe" wrote in message
...
I need to be able to extract such information as start date/time, stop
date/time, subject and description from calendar appointments and export
to
excel. I need to be able to do this at least weekly and, ideally, with
the
click of a button.

I feel pretty sure that if I knew VBS, I could do this pretty easily --
but,
alas, I don't.

Any help would be GREATLY appreciated.

**Diane Poremsky {MVP}[_2_]** · July 15th 08, 05:04 PM posted to microsoft.public.outlook.calendaring

try the outlook.program_vba newsgroup on this server or check out
outlookcode.com

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:

Exchange Messaging Outlook newsletter:

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

"CPOjoe" wrote in message
...
Thanks -- that would work well enough; but, I'm working on this for some
other folks who really want to be able to just "push a button" to get it
done.

So, I'm looking for more of a macro/vbs solution.

Joe

"Diane Poremsky {MVP}" wrote:

if you create a custom view with the fields you need and filter it for
the
records you need, you can copy and paste it into Excel. It's a couple of
more steps but works well.

http://www.outlook-tips.net/howto/copy_data.htm has an example.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:

Exchange Messaging Outlook newsletter:

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

"CPOjoe" wrote in message
...
I need to be able to extract such information as start date/time, stop
date/time, subject and description from calendar appointments and
export
to
excel. I need to be able to do this at least weekly and, ideally, with
the
click of a button.

I feel pretty sure that if I knew VBS, I could do this pretty easily --
but,
alas, I don't.

Any help would be GREATLY appreciated.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Outlook 2003 & Microsoft Fax via Excel Macro to send asattachement	James D Smooth	Outlook - Fax Functions	1	March 17th 08 10:08 PM
Macro to extract subject and sender name of messages in folder to Excel file	bony_tony	Outlook and VBA	0	March 7th 07 02:16 AM
Extract Folder Name From Outlook To Excel	Vadhimoo	Outlook and VBA	1	December 4th 06 07:09 AM
Importing Outlook Alias info into an excel 2003 macro	fidgitthedigit	Outlook and VBA	4	May 31st 06 05:22 PM
Importing Outlook Alias into an Excel 2003 macro	fidgitthedigit	Outlook - General Queries	2	May 30th 06 03:11 PM