OpenOffice.org Training, Tips, and Ideas: Mail Merge OpenOffice Labels, OpenOffice.org 2.0 (Repost)

Here’s how to make labels.

first, get your data into a spreadsheet, a text file, an address book, and create a database. you can do it by choosing file > new > database.

Reading: Openoffice mail merge labels from spreadsheet

This post contains instructions for spreadsheets.

This post contains step 2 instructions for spreadsheets or text files.

then, once you’ve set up the database in openoffice.org, you’re ready to go.

1. choose file > new > labels. (To make envelopes, open an openoffice.org writer document and choose insert > envelope).

2. in the tags tab of the tags window, select the database you created from the database dropdown list. you are looking for the database name you created by selecting file > new > database, not the spreadsheet, address book, or text file that contains the data.

(click on the image to see a larger image).

3. select a table from the list of tables. this will be sheet1 or whatever the name of the sheet is, if you are using a spreadsheet to store your data.

4. Select the first field you want to use from the Database Field list. Mm2

See also: 35 Fantastic Mailbox Ideas and Designs That Will Leave Your Guests Really Impressed | Decor Home Ideas

5. click the arrow next to it to insert it into the label text field.

Type a space after the field and you can add the next field, such as last name.

See Also:  Bật hoặc tắt tùy chọn thư trả lời tự động

6. use the database field list to insert any other fields you need. if you want fields on the second line, click after the last character of the last field you inserted, in the big text box, and just hit enter. if you need to change the array later in the created tag document, you can.

7. in the brand dropdown select a very small font size if you are not using a4.

8. In the Type dropdown list, scroll through the billions of labels. Select the type of label you’re using, 8160 Inkjet Address is a good one but just use whatever is on the envelope of labels.Mm4

9. this step and step 10 and step 15 are optional but recommended. click the options tab.

10. select the sync content option if you want to apply formatting, such as a different font or colors or add graphics, and have those changes apply to all your labels.

11.click the setup button next to the printer screen.

12. select the printer you want to print to.

13. in the printer options (this will vary depending on your operating system) specify the appropriate tray or paper feed. for now, select manual feed.

14. click the new document button at the bottom of the window. labels will appear. This is how it’s supposed to look. you will not see the data, you will see the field names as the name. when you print, the correct data will appear.

See Also:  Freebie: how to create your own gmail tabs

See also: Sign out of gmail

Mm6

15. optional: if you selected the sync contents checkbox

If you need to make changes, such as adding spaces, rearranging fields, or changing formatting, do so in the top left tag. make the text an interesting font or make it the size you need. you can also right click on the top right label border, choose the frame, go to the border tab and give it a background color.

then click synchronize to apply those changes to all tags.

16. choose file > Print. a message will ask if you want to print a form letter. click yes.

17. If you want to print labels only for certain records, you can select them from the record dropdown list. select one, press ctrl, select the next, and so on. or you can select a range of records like 1-20.

Mmprint

18. if you only want to print all labels, select all.

19. When you’re ready, just click OK. you will be prompted again to choose your printer. print normally.

Note: If you are having trouble printing, check your printer settings using your operating system’s configuration tools.

note: you can save the tag document and simply return to it when you need to use it again.

See also: Ut office 365

Leave a Reply

Your email address will not be published. Required fields are marked *