Exporting message log to Excel

[Renee]

Anyone!
I'd like to export a message log (the one that contains all the dates,
as well as the text of the messages) to Excel so I can do some further
analysis. Within IM there seems to be no way to export, or even to
copy/paste.

Is there a way to do this from within IM or does anyone know of a
utility that will do this with all my previous messages?

Thanks!

[Jonathan Kay [MVP]]

Greetings Renee,

If you use Excel 2003, you can just open the XML log files within Excel.
____________________________________________
Jonathan Kay
Microsoft MVP - Windows Messenger/MSN Messenger
Associate Expert
http://www.microsoft.com/windowsxp/expertzone/
Messenger Resources - http://messenger.jonathankay.com
All posts unless otherwise specified are (c) 2004 Jonathan Kay.
You *must* contact me for redistribution rights.

"Renee" > wrote in message
om...
> Anyone!
> I'd like to export a message log (the one that contains all the dates,
> as well as the text of the messages) to Excel so I can do some further
> analysis. Within IM there seems to be no way to export, or even to
> copy/paste.
>
> Is there a way to do this from within IM or does anyone know of a
> utility that will do this with all my previous messages?
>
> Thanks!

[Renee]

Thank you, thank you, Jonathan - this worked without a hitch!




"Jonathan Kay [MVP]" > wrote in message >...
> Greetings Renee,
>
> If you use Excel 2003, you can just open the XML log files within Excel.
> ____________________________________________
> Jonathan Kay
> Microsoft MVP - Windows Messenger/MSN Messenger
> Associate Expert
> http://www.microsoft.com/windowsxp/expertzone/
> Messenger Resources - http://messenger.jonathankay.com
> All posts unless otherwise specified are (c) 2004 Jonathan Kay.
> You *must* contact me for redistribution rights.
>
> "Renee" > wrote in message
> om...
> > Anyone!
> > I'd like to export a message log (the one that contains all the dates,
> > as well as the text of the messages) to Excel so I can do some further
> > analysis. Within IM there seems to be no way to export, or even to
> > copy/paste.
> >
> > Is there a way to do this from within IM or does anyone know of a
> > utility that will do this with all my previous messages?
> >
> > Thanks!

[Renee]

Thank you, thank you, Jonathan - this worked without a hitch!




"Jonathan Kay [MVP]" > wrote in message >...
> Greetings Renee,
>
> If you use Excel 2003, you can just open the XML log files within Excel.
> ____________________________________________
> Jonathan Kay
> Microsoft MVP - Windows Messenger/MSN Messenger
> Associate Expert
> http://www.microsoft.com/windowsxp/expertzone/
> Messenger Resources - http://messenger.jonathankay.com
> All posts unless otherwise specified are (c) 2004 Jonathan Kay.
> You *must* contact me for redistribution rights.
>
> "Renee" > wrote in message
> om...
> > Anyone!
> > I'd like to export a message log (the one that contains all the dates,
> > as well as the text of the messages) to Excel so I can do some further
> > analysis. Within IM there seems to be no way to export, or even to
> > copy/paste.
> >
> > Is there a way to do this from within IM or does anyone know of a
> > utility that will do this with all my previous messages?
> >
> > Thanks!

[Renee]

Thank you, thank you, Jonathan - this worked without a hitch!




"Jonathan Kay [MVP]" > wrote in message >...
> Greetings Renee,
>
> If you use Excel 2003, you can just open the XML log files within Excel.
> ____________________________________________
> Jonathan Kay
> Microsoft MVP - Windows Messenger/MSN Messenger
> Associate Expert
> http://www.microsoft.com/windowsxp/expertzone/
> Messenger Resources - http://messenger.jonathankay.com
> All posts unless otherwise specified are (c) 2004 Jonathan Kay.
> You *must* contact me for redistribution rights.
>
> "Renee" > wrote in message
> om...
> > Anyone!
> > I'd like to export a message log (the one that contains all the dates,
> > as well as the text of the messages) to Excel so I can do some further
> > analysis. Within IM there seems to be no way to export, or even to
> > copy/paste.
> >
> > Is there a way to do this from within IM or does anyone know of a
> > utility that will do this with all my previous messages?
> >
> > Thanks!

[Renee]

Thank you, thank you, Jonathan - this worked without a hitch!




"Jonathan Kay [MVP]" > wrote in message >...
> Greetings Renee,
>
> If you use Excel 2003, you can just open the XML log files within Excel.
> ____________________________________________
> Jonathan Kay
> Microsoft MVP - Windows Messenger/MSN Messenger
> Associate Expert
> http://www.microsoft.com/windowsxp/expertzone/
> Messenger Resources - http://messenger.jonathankay.com
> All posts unless otherwise specified are (c) 2004 Jonathan Kay.
> You *must* contact me for redistribution rights.
>
> "Renee" > wrote in message
> om...
> > Anyone!
> > I'd like to export a message log (the one that contains all the dates,
> > as well as the text of the messages) to Excel so I can do some further
> > analysis. Within IM there seems to be no way to export, or even to
> > copy/paste.
> >
> > Is there a way to do this from within IM or does anyone know of a
> > utility that will do this with all my previous messages?
> >
> > Thanks!

[Jonathan Kay [MVP]]

Hi Renee,

Glad to hear it =). Once you have them open in Excel you can sort the cell's and everything;
it's rather nice functionality.
____________________________________________
Jonathan Kay
Microsoft MVP - Windows Messenger/MSN Messenger
Associate Expert
http://www.microsoft.com/windowsxp/expertzone/
Messenger Resources - http://messenger.jonathankay.com
All posts unless otherwise specified are (c) 2004 Jonathan Kay.
You *must* contact me for redistribution rights.

"Renee" > wrote in message
om...
> Thank you, thank you, Jonathan - this worked without a hitch!
>
>
>
>
> "Jonathan Kay [MVP]" > wrote in message
> >...
>> Greetings Renee,
>>
>> If you use Excel 2003, you can just open the XML log files within Excel.
>> ____________________________________________
>> Jonathan Kay
>> Microsoft MVP - Windows Messenger/MSN Messenger
>> Associate Expert
>> http://www.microsoft.com/windowsxp/expertzone/
>> Messenger Resources - http://messenger.jonathankay.com
>> All posts unless otherwise specified are (c) 2004 Jonathan Kay.
>> You *must* contact me for redistribution rights.
>>
>> "Renee" > wrote in message
>> om...
>> > Anyone!
>> > I'd like to export a message log (the one that contains all the dates,
>> > as well as the text of the messages) to Excel so I can do some further
>> > analysis. Within IM there seems to be no way to export, or even to
>> > copy/paste.
>> >
>> > Is there a way to do this from within IM or does anyone know of a
>> > utility that will do this with all my previous messages?
>> >
>> > Thanks!