A
amysmel
How do I export multiple shared calendar appointments into an Excel
spreadsheet?
spreadsheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
have you tried "File, Import and Export"?
M
Mel
Yes, I have. It's exporting my calendar, not the shared calendar that I need
to export.
to export.
B
Bob I
If this "shared" calendar is on the exchange server, I copy it to a temp
calendar in my account and export from there.
calendar in my account and export from there.
D
Diane Poremsky [MVP]
create a table view with the fields you want then copy and paste into Excel.
http://www.outlook-tips.net/howto/copy_data.htm
** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
http://www.outlook-tips.net/howto/copy_data.htm
** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
M
Mel
That's what I used to do before I got Outlook 2007. I can't figure out how
to do that with the 2007 system.
to do that with the 2007 system.
B
Bob I
Sorry, haven't played with the 2007 version yet. What does the F1 key
and "Export" or "Copy folder" reveal?
and "Export" or "Copy folder" reveal?
D
Diane Poremsky [MVP]
Copying the calendar works the same way in outlook 2007.
** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
M
Mel
When I try to copy the calendars up into my calendar info, it says it can't
copy because there may be private items. I have Editor permissions on all
these calendars. Any ideas as to why I'm getting the message about private
items?
copy because there may be private items. I have Editor permissions on all
these calendars. Any ideas as to why I'm getting the message about private
items?
M
Mel
When I try to export or copy the calendars, the message comes up that it
cannot copy because there may be private items.
cannot copy because there may be private items.
B
Bob I
That's a bit odd, try opening them and look at the "private" box. In
2003 you can't set "private".
2003 you can't set "private".