OpenOffice.org OpenOffice - 2014 Manual de usuario descargar pdf (Pagina 42)

Author’s or editor’s name is entered in another menu:  Tools  › Options  › User data.
This makes sense since the same document might well be edited by various people in succes-
sion – see section 11 on Proofreading.
47 Labels and Form Letters
This is not what you are going to need for your studies. But perhaps in the course of a trainee-
ship or at your work place you might be asked to print out labels for a bulk mailing. It’s really
quite easy:
1. Create a file Spreadsheet and use the first line for the Column Headings: “Name”,
“Street”, “City”, “Telephone number”, “Mobile number” and “Email”. Fill in the lines
below with all relevant information using one line per person. Then save the spread-
sheet under some meaningful name such as “addresses” (the file ending .ods will be
automatically appended).
2. Create a file Database. Choose the option Connect to an existing database
and select  Spreadsheet  from the drop-down menu. Confirm  Next, locate the
spreadsheet you saved in previous step and Open it. Confirm Yes, register the
database for me (this allows you to communicate with the database from any open
file). Remove the tick from Open the database for editing. Press Finish, give
your new database the same name as your spreadsheet (the file ending .odb will be
automatically appended, so you end up with two separate files with the same name but
different endings) and Save.
3. Create a file Labels. Under the tab Labels select your Database from the drop-
down list and again the pertaining  Table  from the drop-down list immediately
below:  sheet1. Now choose your first  Database  Field, “Name”, and move it
using the arrow to the white area on the left. Insert a new line. Now move your next
Database   Field, “Street”, and press Return twice to have an empty line before
inserting your last Database Field, “City”. The other fields (Telephone, Mobile and
Mail) are of  no interest to you for the purpose of  your bulk mail. Open the tab
Format and insert the values listed in table 8 and illustration 30 (these apply to A4-
paper with 3 x 8 labels). Press button New document. At this point a new page will
appear full of  Field names as in illustration 31. You can now print your document on
label sheets. During the printing process the place holders will get replaced by the
actual names, streets and cities listed in your spreadsheet.
39

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 48 49

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 2014 Manual de usuario Pagina 42

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 2014