On Monday June 12 2006 04:31 pm, Dennis Marks wrote:
> I created a database using Calc since it is very easy to maintain for
> very simple tables. I used the Mail Merge Wizard to attach it to a
> Writer document. It seems as though the wizard created a Base file with
> the Calc data and that is what is being used for the merge.
>
> Am I able to use a Calc document directly or does it have to be a Base
> file for mail merge? Do I have to do all my updates in the Base file
> now? Is the original Calc file of any use other than backup?
Actually, the Base file only serves as the connector between your Calc
file and Mail Merge. The Base file will only read from the Calc file: it
CAN NOT make any changes in it. So, the original Calc is the only place
where you can make any changes to your data.
For that matter, if you want to change the number of columns you use
in the Calc file, these will show up in the base file as additional
fields. I have a Calc file that had two columns that I wanted to use as a
data source. So, I created the Base file for it and registered it. When I
changed the number of columns from 2 to 4 with column headings, the next
time I used F4 to view the data in that Calc file, there were 4 columns in
the Base table matching up with the column headings of the Calc file.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
