export calendar label

[tricia]

hi,

i would like to know if there is a way to export the labels
from appointments in the calendar?

thanks.

 

[Jocelyn Fiorello [MVP - Outlook]]

Export them to what?

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In

 

[Gar]

Hi,

I'm working through the same problem, using Outlook 2003 (although
I've tried the same thing in earlier versions). I use custom label
names to categorize appointments (not ideal, but Outlook doesn't
appear to provide alternatives), and want to export all appointments
from a block of time into Excel (or Access, or a CSV, TSV, doesn't
matter). It lets me select most of the fields (time, date, subject,
categories, description, etc), but it does not list "label" as an
option. As I need to capture this information in a report, my
alternative seems to be manually modifying over 1000 records in my
output spreadsheet, manually cross-referencing each with the
corresponding appointment in Outlook. Clearly, not a satisfactory
option.

In my research, the only suggestion I've seen is to programatically
extract this info with VB. As I'm not a programmer, that doesn't help
me much. Any other suggestions?

Thanks,
Chris

 

[Jocelyn Fiorello [MVP - Outlook]]

Sorry, I don't know of any other way to export the label data without
programming (not saying there isn't a way, I just don't know any other way
myself). Just out of curiosity, what do you mean when you say Outlook
doesn't provide any other method of categorizing appointments besides the
labels? The actual Categories feature doesn't help you at all?

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In