The first option is what I have been doing - it uses a calc file to
drive a mailing list. The logic is in the document, not in the calc
file, so that I can bring in new data without a lot of effort - the raw
data can just be a .csv file.
The second option, using a "smart" calc file, moves the
Gary,
See attached for a working case when in LO Base. You do have to be very
careful when using Base Queries (SQL) that everything is exactly correct
like where commas are placed (or not) and how quotes / half quotes are used
(or not). So setting this up in Base will likely take more time than
Good night, hi all:
I have two options when I conect to a external spreadsheet data with
BASE:
1) Conect with the third option when start the wizard selecting:
spreadsheet.
In this case we can import the structure and data from it.
The first options is keep the conections with the
Thanks Bruce. I appreciate the help. I was trying values from a table
that translates age ranges into text. I hate hard coding numbers, let
alone the number of ranges, because I handle events for two different
groups who have their own definitions. They used to be encoded in the
different