Please tell me there's a quicker way- Spreadsheet to Shipping labels
So my work database spits out excel spreadsheets that have to become shipping labels. Here's my turn-by-turn workflow. 1. I manipulate them a bit in Calc. Can't Save As a .odb, so then I have to do step 2. 2. I open the .ods in Base for the only purpose of saving it as a .odb and "registering" as a database. 3. Open Writer, go to File->New->Labels.
Unless I do step 2, the file I want to use won't be there in the "database" drop down menu in the Labels wizard.
I would really like to eliminate the step using Base entirely.
But I can't seem to figure out how to Save As .odb from Calc (you can Save As DBASE .dbf but not .odb?). Likewise, I can't seem to figure out how to use a .ods in a data merge in Writer (been told one can only use "registered" .odb files, but really hoping that's false). Or something else. Do you have a time-saver, step-skipping suggestion for me?
ALSO, the column headers are ALWAYS the same on all my source files. So, something like "ItemCode" will always be column headed by ItemCode. But when I switch out one source file for another, the data merge seems to require me to completely rebuild my field layout even though the new file has the same column headers as the old file because the Labels layout window still refers to the old source file even though I have chosen a new registered database. What's up with that?
Thanks.