Instead of using Address3, use City, State, Country and Postal Code in separate columns. For example instead of using Name, consider separating Name into First and Last. It is a lot easier to automatically concatenate (put thing together) than it is to automatically break compound fields apart. Break fields apart when you create a spreadsheet. The data in each column is known as a field. Each address will occupy one row or record in your spreadsheet. Each row of the spreadsheet represents a record. The last thing you want to do is have your labels peel off there backing and gum up the works inside your printer! Guidelines for Creating an Address Book Spreadsheet. Use the paper tray/path that your printer manual recommends for labels. Using an inappropriate type of labels, can cause damage to your printer! Heed any warnings about restrictions regarding refeeding a label sheet into a printer. Inkjet labels for inkjets, laser for laser printers. Purchasing the labels Buy labels that match your printer. That is especially true for the 55+ generation, where internet access and addresses are not universal. Although snail mail is slowly giving way to, there are many circumstances where you need to do an old fashioned mailing. The techniques will need to be adapted if you are using something other than OpenOffice. 1 of 16 Creating Mailing Labels in Apache OpenOffice We will be using Apache OpenOffice, which is available as donation-ware from to create mailing labels.

Openoffice excel templet for labels