outlook 2003 macro to extract calendar appointment info to Excel

  • Thread starter Thread starter CPOjoe
  • Start date Start date
C

CPOjoe

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.
 
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/



Exchange Messaging Outlook newsletter:
(e-mail address removed)




** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
 
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} said:
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/



Exchange Messaging Outlook newsletter:
(e-mail address removed)




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


CPOjoe said:
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.
Click to expand...
Click to expand...
 
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/



Exchange Messaging Outlook newsletter:
(e-mail address removed)




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


CPOjoe said:
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} said:
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/



Exchange Messaging Outlook newsletter:
(e-mail address removed)




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


CPOjoe said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top