Exporting Hotmail Contacts - OpenOffice Calc

[C M Reinehr]

James,

On Wednesday 28 March 2007 19:00, James McDonald wrote:
> I was trying to export my wifes free hotmail account contacts out.
>
> They are clever I will give them that. There is no facility to export
> the contacts to csv etc. The hotmail display of contacts does a semi
> random obsfucation (replacing some of the last few characters in the
> email address with `...') to stop you simply copying them off the web page.
>
> I had to copy the lot into oocalc and then manually complete each email
> address.
>
> I noticed oocalc doesn't have a native text to column feature (oowriter
> does). I always use this feature in excel so I had to download and
> install a plugin from the OpenOffice Macro Add-in site
> http://www.ooomacros.org/user.php which is quite handy for adding
> functionality that isn't in the core distribution.

	I'm not sure we're talking about the same thing, but if you want to open a 
text file in OO.org Calc with the intention of organizing the text into 
columns you just need to select a File Type of "Text CSV" from the file open 
window. After selecting the file a second window will open allowing you to 
specify fixed width or variable, separated by tab, comma, etc.

cmr

> A difference I found comparing Excel with OpenOffice is that the Formula
> argument separator is `;' while Excel uses `,' so I had a few head
> scratching moments while I re-read my formulas and got the syntax right.
>
> So now all I need to learn is how to Automate OpenOffice and I will be
> able to leave m$ licensing alone forever.
>
>
>
>
> _______________________________________________
> Linux-users mailing list ( Linux-users at linux-sxs.org )
> Unsub/Password/Etc:
> http://mail.linux-sxs.org/cgi-bin/mailman/listinfo/linux-users
>
> ***  OFF TOPIC conversations should get sent to general at linux-sxs.org. 
> This rule will be strictly enforced.  ***
>
> Need to chat further on this subject? Check out #linux-users on
> irc.linux-sxs.org !

-- 
Debian 'Etch' - Registered Linux User #241964
--------
"More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC