How to Print Address Labels Using OpenOffice
Click on File >> New >> Labels., Click on the Options tab. , Be sure that the Synchronize Contents box is unchecked. , Select the Labels tab. , In the Database pull down menu, select Addresses. , In the Tables pull down menu, select Sheet 1 (unless...
Step-by-Step Guide
-
Step 1: Click on File >> New >> Labels.
This will bring you to the Labels dialog screen. -
Step 2: Click on the Options tab.
,,,,, In the US, the standard is Avery. , A popular one is Avery
5260. , For an address, you would start off with the first name. , This puts the appropriate field in the correct place in the label. ,,, This takes you to the second line. ,, Add the name of the city Type in a comma (,).
Hit the space bar and then add the State Field.
Hit the space bar and then add the Zip code field. , This is what it should look like now (the new document). , A box will come up and ask if you want to print a form letter. ,, -
Step 3: Be sure that the Synchronize Contents box is unchecked.
-
Step 4: Select the Labels tab.
-
Step 5: In the Database pull down menu
-
Step 6: select Addresses.
-
Step 7: In the Tables pull down menu
-
Step 8: select Sheet 1 (unless you renamed it).
-
Step 9: In the Brand pull down menu
-
Step 10: select the correct brand name for your labels.
-
Step 11: In the Type pull down menu
-
Step 12: select the type of label that you will be using.
-
Step 13: In the Database Field pull down menu
-
Step 14: select the field you want.
-
Step 15: Click the left pointing arrow indicated above in the screenshot.
-
Step 16: Press the space bar to create a space in the 'Label text' block.
-
Step 17: Using the Database Field pull down menu
-
Step 18: select the last name.
-
Step 19: Hit Enter.
-
Step 20: Using the same process
-
Step 21: continue.
-
Step 22: Add the Street field.
-
Step 23: Click on New Document to create your sheet of labels.
-
Step 24: Click File >> Print (Ctrl P).
-
Step 25: Select Yes.
-
Step 26: Be sure that Printer and the records that you want to print are selected and print.
Detailed Guide
This will bring you to the Labels dialog screen.
,,,,, In the US, the standard is Avery. , A popular one is Avery
5260. , For an address, you would start off with the first name. , This puts the appropriate field in the correct place in the label. ,,, This takes you to the second line. ,, Add the name of the city Type in a comma (,).
Hit the space bar and then add the State Field.
Hit the space bar and then add the Zip code field. , This is what it should look like now (the new document). , A box will come up and ask if you want to print a form letter. ,,
About the Author
James Reed
Specializes in breaking down complex practical skills topics into simple steps.
Rate This Guide
How helpful was this guide? Click to rate: