On 01/05/2007, at 2:30 AM, Solveig L Haugland wrote:
Hi,
I was wondering if there's a way to make database field values,
like Bob Jones and 401 Main Street, stay displayed in a mail merge
document when I re-open it. I can get the values to display by
clicking the Data to Fields icon. However, when I close and reopen
the document, the field names are displayed again, and I need to
click the Data to Fields icon again to redisplay the content.
Hi Solveig,
This is the way it is designed, so that the database values can be re-
used next time you do another letter, form etc. If you need a
"permanent" copy of the document with the values, I believe you are
required to either print it, or save it as another document name.
In a related topic, is there a way to import User Variable fields
and their values from one document to another? I'd like to be able
to use multiple documents to store the same values like Contractor
Name, Contractor Address, etc. User Variables would be great if
there were a mass update/import. I can use Insert Reference and Set
Reference to cross-reference the user variables from one doc to
another but the correct values aren't displayed except when viewed
from the master document and that won't work for my client's purposes.
lol! This is an area I came across a couple of years ago when dealing
with xforms. Under xforms it seemed that you could do this by simply
dragging the fields to other documents, an while both were open it
worked, but once re-opened the copy had no values at all. This was
due to an apparent "bug" that was more feature than bug, but did not
work as people would have wanted. There is no way of taking values
across the forms unless you store it in a database. This is
essentially the solution for the scenario you describe. Other
software solutions were put forward based on xforms using "XPipes"
and similar 3rd party methods, but nothing has been implemented
either in OpenOffice.org or as a standard for this problem.
General question: does anyone have a better way than database
fields or variables, for this issue? I want to store the same
values across multiple subdocuments that form one large document,
about 300-500 pages. The method must allow the document user to
update the values by changing one value and having all instances of
that same field in all documents update with the new value. The
update is easier with bringing in fields from a database, but the
display thing is a bit annoying to have to do every time. Also, the
user needs to be able to email out subsections of the document to
people outside the company, and have all field values correctly
displayed.
Yep, the exact problem I was looking at. Not sure if any solution is
possible in OpenOffice.org at this stage other than database.
Regards
Jonathon
Thanks,
Solveig
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED]
OpenOffice.org 2.0 and StarOffice 8.0 Training, Consulting, and
Learning Materials
http://www.getopenoffice.org
OpenOffice.org Blog: Tips and Tricks, News and Ideas
http://www.openoffice.blogs.com
"OpenOffice.org 2 Guidebook"
http://openoffice.blogs.com/bookresources
http://www.cafepress.com/getopenoffice/2144270
http://www.amazon.com/OpenOffice-org-Guidebook-Solveig-Haugland/dp/
0974312029
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------
Jonathon Coombes
OOo Knowledgebase:- http://mindmeld.cybersite.com.au
http://www.cybersite.com.au
http://www.training4linux.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
