Getting addresses OUT of a spreadsheet

[NoOp]

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