From openoffice-users  Thu Dec 12 12:29:14 2002
From: Tom Melvin <tom () tkrh ! demon ! co ! uk>
Date: Thu, 12 Dec 2002 12:29:14 +0000
To: openoffice-users
Subject: Re: [users] Mail Merge
Message-Id: <20021212122914.GA19003 () tkrh ! demon ! co ! uk>
X-MARC-Message: https://marc.info/?l=openoffice-users&m=111523190546353

CP Hennessy made comment on Thu Dec 12 09:56:54 2002 :
> On Thursday 12 December 2002 09:12, Tom Melvin wrote:
> > CP Hennessy made comment on Thu Dec 12 00:28:36 2002 :
> > > "Tools" -> "Data Sources..."
> > >   "New Data Source"
> > > 	Tab "General"
> > > 	    "Database type" : "Text"
> > > 	    "Data source URL : browse to whereever your csv file is.
> > > 	Tab "Text"
> > > 	    File in various obvious flelds
> > >
> > > And then in your Form file reference this datasource.
> >
> > Yes found that - set that up and for one run it is great. But if the
> > letter is saved in OOo and then the datasource (csv file) changes and
> > the letter re-opened the contents are set to the old data. OOo does not
> > seem to refresh the data like MicroSoft Word does.
> 
> So you saved the form letter and then reopened it, or reopened the form
> "template" ?

Not using templates, just created a form letter, Inserted fields from
the DataSource. Was sort of expecting a 'button' to toggle between
Field Names and the Actual data - but not found that yet. If I use
the 'DataSources' button then yes the new data is there - the only way
to re-fresh is if I actually print.

Does that make sence?

Tom

> > > On Wednesday 11 December 2002 22:51, Tom Melvin wrote:
> > > > Tom Melvin made comment on Tue Dec 10 16:41:07 2002 :
> > > > > I can create a mail merge document pointing to a Data source  Ok but
> > > > > when the data source 'changes' (it's a csv file) and I re-load the
> > > > > letter the contents initially displayed do not change - they show the
> > > > > 'old' data.
> > > > >
> > > > > Is there a way to get OpenOffice.org to 'refresh' the data without
> > > > > user intervension?.
> > > >
> > > > If using a CSV file to pass info into OOo won't work is there a
> > > > guide/FAQ somewhere that explains how to 'pass variables' into OOo. OOo
> > > > is running under SuSE and accessing text files (can be any format) over
> > > > an NFS share from SCO OpenServer.
> > > >
> > > > I need to 'grab' client/name and address details and automatically
> > > > insert them into a letter/handout without users have to do much
> > > > clicking.
> 

-- 
========================================================================
Tom Melvin   tom@tkrh.demon.co.uk          http://www.tkrh.demon.co.uk
Veterinary Solutions Ltd                   Sysop Compuserve Unixforum
========================================================================