Lorrie Pinkley wrote:
I have a spreadsheet we created in openoffice Calc, it has our clients names address' type of loan, interest rate etc.... I would like to print labels with only their name and address on the envelope and also would like to do a mail merge and be able to have each of our clients names printed in the "Dear..." secion of hte letter. Can you help me figure this out? I have went into the help secion of openoffice and read thru the directions but do not understand them. I wonder if we need to convert our spreadsheet to a 'database'???? Please advise. Thank you so much.
Yes, first you need to "register" your spreadsheet as a data source. To do this, select File > New > Database, select "Connect to an existing database", and select the type of data source (spreadsheet) to connect to. The exact source can then be chosen in the wizard.
After you have done that, these two chapters in the Writer Guide should help you:
Using Mail Merge, http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailMerge.pdf Printing with Writer, http://documentation.openoffice.org/manuals/oooauthors2/0205WG-PrintingWithWriter.pdf Regards, Jean Jean Hollis Weber --------- Get printed copies of "Getting Started with OOo2.0" and "OOo Writer Guide" from http://www.lulu.com/opendocument Free PDFs are at http://documentation.openoffice.org/manuals/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
