Exporting message log to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Renee - 28 Jul 2004 16:16 GMT

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!

Reply to this Message

Jonathan Kay [MVP] - 28 Jul 2004 21:57 GMT

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.

> Anyone!
> I'd like to export a message log (the one that contains all the dates,
[quoted text clipped - 6 lines]
>
> Thanks!

Reply to this Message

Renee - 29 Jul 2004 23:21 GMT

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

> Greetings Renee,
>
[quoted text clipped - 18 lines]
> >
> > Thanks!

Reply to this Message

Jonathan Kay [MVP] - 30 Jul 2004 15:43 GMT

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.

> Thank you, thank you, Jonathan - this worked without a hitch!
>
[quoted text clipped - 20 lines]
>> >
>> > Thanks!

Reply to this Message