[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ubuntu-users
Subject:    Getting addresses OUT of a spreadsheet
From:       glgxg () sbcglobal ! net (NoOp)
Date:       2008-02-29 17:11:27
Message-ID: fq9ec0$9l5$1 () ger ! gmane ! org
[Download RAW message or body]

On 02/28/2008 10:42 PM, Brian Astill wrote:
> On Thu, 28 Feb 2008 09:55:10 pm Karl Auer wrote:
> > That will work - if the data is in a database or a text
> > document, or if you want to use a system address book, say out
> > of evolution. Can't see any way to get at the data in an OOo
> > spreadsheet...
> 
> Nor should you expect to do so.
> A word processor _can_ produce flyers and brochures, but it 
> doesn't do these things well because that is not what it is 
> designed to do.
> A spreadsheet _can_ store and sort data but it doesn't do these 
> things well because that is not what it is designed to do.
> 
> Unless you have compelling reasons for storing names and addresses 
> in a mathematical manipulation program, you would be best advised 
> to export to CVS, transfer to a database and avoid any further 
> frustration.
> 

Ummm... OOo Writer does an excellent job of using a spreadsheet (.ods or
.xls) as a data source for mail merge & label. In fact the most common
examples use a Calc spreadsheet as that is generally the simplest method:

<http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Creating_the_data_source>
 http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailMerge.pdf


[prev in list] [next in list] [prev in thread] [next in thread]