At 10:22 05/11/2007 -0500, Meghan Fisher wrote:
I need to know how to print mailing labels from a database. I have
typed in 500 names and addresses and cannot print them. It is very
confusing. I tried the mail merge because that's what I used on Microsoft.
I'm not an expert in this, but since I haven't seen a full answer,
I'll have a stab.
You say that you want to print labels "from a database", but your
subject line says that you are "using Calc". So I'm guessing that
your database is actually a spreadsheet, as it were. The bad news is
that Writer's labels facility does not, I think, know how to merge
addresses from a Calc spreadsheet: only from a true database. But
don't panic: you will not need to retype everything, since there is a
workaround. First, you need to transfer the information you have
already typed into a Base database, and then use that to create the
labels in Writer.
To create the new database:
o Go to File | New > | Database.
o On the first panel select "Connect to an existing database" and
then Spreadsheet from the drop-down menu.
o On the second panel, browse to your existing Calc spreadsheet.
o On the third panel, select "Yes, register the database for me".
o Save the database.
If you now click on Tables in the left column, you will see a table
listed in the lower panel. If you wish, double-click on this and you
will see your addresses reassuringly shown in a table. You can now
close the table and the database.
To create the labels:
o Go to File | New > | Labels.
o Select the label style and other parameters, and then New Document.
o Go to View | Data Sources (or just press F4).
o You should see your new database listed in the Data Sources
window. Expand it and the Tables entry to display the particular
table containing your addresses.
The rest of the technique for inserting data from the database table
into the individual labels is described well in the help text, so go
to Help | OpenOffice.org Help (or just press F1), search for "labels"
and then double-click the "from databases" entry below it. Follow
the instructions there. In particular, take care over points 7, 8,
and 9: if you don't get these right, you will get many copies of the
first label instead of the different labels that you need. You may
need to experiment a bit to get everything right.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
