by ColoQuery » Wed Mar 25, 2015 1:22 am
Oh, my goodness! We're getting there!! Only a couple of (I believe) much smaller questions left. Here's what I've done so far, at your suggestions:
I went back and resaved my merge file into the *.odt extension, and did the same for my spreadsheet. Went through the connection process to connect the new *.ods spreadsheet file to the new *.odt merge file. Re-drug each field name into the new *.odt file as the follow-up to the connections process, and resaved, being careful to retain the *.odt extension. When I opened the merge file again, THE FIELDS STAYED LIVE!! So exciting!
Acknak, I tried your suggestion of using the "Data to Fields" trick to produce a single record -- that worked like magic! I could not highlight a group of records and have it do subsequent pages for the continuing records, but for a single one, it was beautiful! My bookkeeper is going to do handsprings (and he's a big guy -- this won't be pretty!)
==> Here's the "next step" question: After testing the printing of a group of records from the *.ods spreadsheet, printed to a file, there was an extra page between each record-page printed. The page did not show up on the print preview, so I could not delete it before printing. This would cause brain damage if printing actual checks! Is there an <endpage> or <endrecord> code of some sort that I need to insert on my merge document to keep it one record per page, with no extra pages sneaking in?
Once again, thank you so very much!
OpenOffice 4.1.1 on Windows Vista