On Wednesday March 07 2007 8:12 pm, Joe Marks wrote:
> I have an address book on a Calc spreadsheet. How do I print the
> addresses onto envelopes?
Two ways: cut and paste. (Probably time consuming.)
Second way: create a database linked to the Calc spreadsheet.
Then you can use F4 to open the data window. Browse to the desired
table based upon the sheet in Calc with the addresses. Again you can
copy and paste, or you can use Insert > Fields > Other > Databases.
Select Mail merge fields as the Type and the fields that contain the
address. Select the row that contains the information you want on the
envelope, and click the Data to Fields icon.
Probably a better explanation can be found in the Mail Merge
chapter of the OOo Author Writer Guide available at
http://documentation.openoffice.org/manuals/.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
