Getting addresses OUT of a spreadsheet

Karl Auer kauer at biplane.com.au
Thu Feb 28 11:56:52 UTC 2008


On Thu, 2008-02-28 at 12:29 +0100, Kristian Rink wrote:
> Karl, *;
> 
> Am Thu, 28 Feb 2008 21:38:44 +1100
> schrieb Karl Auer <kauer at biplane.com.au>:
> 
> > I have an OOo spreadsheet containing address information. Column A is
> > the surname, column B is the first name, column C is the street and
> > number and so on.
> >
> > How do I get this information into (say) a form letter? Without
> > manually copying it all in, I mean.
> 
> Out of curiosity: What keeps you from utilizing, say, a small OOBasic
> macro to do that job? Asides this, this kind of work also can be
> adressed pretty well using the UNO remoting in OpenOffice and some
> supported language (Python, Java, ...). But that's possibly another
> story...

Thanks for the hints, but if either UNO or OOBasic is required to do
something as simple as a mailout from spreadsheet data then as far as
I'm concerned it's just not a feature. Shame - MSWord/Excel do it quite
well.

Anyone got a way to open this box *without* a welding torch?

Regards, K.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Karl Auer (kauer at biplane.com.au)                   +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/                  +61-428-957160 (mob)

GPG fingerprint: DD23 0DF3 2260 3060 7FEC 5CA8 1AF6 D9E3 CFEE 6B28
Public key at  : random.sks.keyserver.penguin.de

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20080228/eecd3a3f/attachment.sig>


More information about the ubuntu-users mailing list