It can be helpful to label each column for the smallest amount of information possible. [1] X Research source For example, instead of a single column called Address, you could use StreetAddress, State, and Zip. Instead of one column for Name, you could do FirstName and LastName. The actual header columns should be personalized to your needs.
You don’t need to use any special formatting or styles (such as bold print) since the data will be formatted by your mail merge document.
Click the File menu at the top-left and select Save as. Browse to the folder in which you want to save the file. You’ll need to remember this location. Select ODF Spreadsheet (*. ods) from the “Save as type” or “Format” drop-down menu. Click Save. At this point, feel free to close the Calc app.
Don’t worry about drafting your letter or document yet—you’re just connecting the addresses to Writer for now.
Click the File menu at the top-left. Click Wizards on the menu. Click Address Data Source.
To verify that you’ve selected a spreadsheet that can be used, click the Test Connection button at the bottom-right corner. You should see a message that says the connection was established successfully. If you see an error, you may have selected the wrong file or saved it in the wrong format.
To verify that you’ve selected a spreadsheet that can be used, click the Test Connection button at the bottom-right corner. You should see a message that says the connection was established successfully. If you see an error, you may have selected the wrong file or saved it in the wrong format.
If the “Embed this address book definition into the current document” box is checked, uncheck it now. The “Address book name” field is the way this address list will appear in other LibreOffice apps. Feel free to change this if you’d like.
The database will remain available for use in future form letters or documents as well.
When you drag a column header to the desired location, it’ll show up with triangle brackets on either side (ex:
When you drag a column header to the desired location, it’ll show up with triangle brackets on either side (ex:
If you’re printing a form letter, click the File menu and select Print. You’ll be asked if you want to print a form letter—select Yes when prompted. If you don’t want to print letters for all of the people in the address list, hold the Ctrl (PC) or Command (Mac) key as you click the ones you do want to print. Click OK, and then print as desired. If creating labels, go to File > New > Labels, select the database, table, and fields. At the bottom, select the type of label paper you’re printing to (e. g. , Avery A4) and other additional label-making preferences, and then click Save. From there, on the Options tab, click Synchronize contents, and then New document to create your label sheet. You can then print that document as needed by selecting File > Print.
