----- Original Message -----
From: "Pam & Dennis" <[EMAIL PROTECTED]>
Subject: [users] How to create mailing labels from an ods/Calc file
Just downloaded OpenOffice today and want to create my Christmas card labels
in Writer from a Calc/ods spreadsheet. Have done labels this way many times
with Word/Excel 97 (but not 2003 yet - I see the process is quite different
in that program, too). It looks like I need to get the Calc spreadsheet to
show up as a Data Source in Writer. If so, how do I do that? Or when the
Data Source window is open how do I browse to find the Calc address
spreadsheet? Sure do appreciate your help...I've read, read, read and tried
everything I can think of...I'm really stumped! Thanks - Pj
[EMAIL PROTECTED]
-----------------------------------------------
Here is what I do for my Christmas list, using OOo Calc 1.1.4:
Arrange your address book data in separate columns in a spreadsheet, such as
A for Name, B for street address, C for city, etc. Use a descriptive label
in row 1 (for example: "name", "street", "citystate", "zip"). Then you can
"define the data range" and "register the data".
Highlight the entire set of data (all the rows, including the titles, and
all the columns). Then select the following drop-down menus: DATA > DEFINE
RANGE and fill in a name for this set of data (say, "2005List").
Click the MORE tab and be sure to check the box for "Contains column
labels". Click OK.
Save the file.
Next, open a new spreadsheet, select TOOLS > DATA SOURCES. Click on "New
Source" (the button over the left-hand column).
On the "General" tab, fill in a name for this source and select
"Spreadsheet" as the "Data Base Type" (use the down arrow beside the box to
see "Spreadsheet" and click on it). Then open the "Data Source URL" fill-in
box, browse your files (click on the button to the right of the box) and
click on the specific spreadsheet (and "OK" or "Open" or whatever your file
browser's button says). Then "OK" the Data Source Admin box.
Now to actually print your labels: using the open but empty Calc sheet, do
FILE > NEW > LABELS.
On the Labels tab, do:
Database: select the one that you just created a few steps earlier.
Table: select yours
Field: These will be the column labels from the spreadsheet (Name,
street, etc). Select them one at a time, in the sequence you want on the
printed label. Move them over to the left of the screen with the arrow.
Insert whatever spacing (especially line feeds), punctuation, constant text,
etc. that is appropriate. Anything you insert will also be printed.
Brand and Type: select for your specific labels.
Click on "New Document", then "Synchronize" Labels". Note that your data
does NOT display on the screen, only the data fields are displayed.
Print it! (FILE > PRINT or use your normal print icon).
Now, respond YES to the question about "Do you want to print a form letter?"
The Mail Merge dialog opens; select the records ("all", or some limited
number to test with). "OK"; print dialog... "OK".
The labels should now be printed (and, too late for proofreading, they are
also now displayed on the screen).
Hope this helps...
-- John Viestenz
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
