----- Original Message -----
From: "judy brkovic" <[EMAIL PROTECTED]>
Subject: [users] making labels
gentlemen:
i have been trying for two weeks to figure out how to make labels and
print them. i am trying to make labels from my windows outlook express
address book as the data base, which i transferred to a data base using
auto pilot. i want one label for each name and address in the book, i
don't want to make all the labels with the same name on them. i tried
dragging the names into the label fields that are displayed, but can only
drag the first name into the upper left hand corner of the labels, how do
you get the rest of the names into the other labels, and how do you print
them. i tried to follow the help instructions but don't fully understand
them. please help, i'm trying to do my christmas card list.
Judy -- I don't know about doing it from a separate data base (or using auto
pilot), but I think I can provide some help if you can get the addresses
into a Calc spreadsheet. (I am, by the way, using version 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]
