Hi, please help,
I need step by step instructions on how to create mailing labels from the information in my Calc document. I have seperate fields for first name, last, address, city, etc.
thanks
[Solved] Mailing labels
Re: Mailing labels
First you must register your Calc file as a data source.
File > New > Database, bullet "Connect to existing database", set the drop down menu to Spreadsheet and complete the wizard.
Do the labels.
File > New > Labels. On the Labels tab your Database, Table(s) and field names will be available on the drop downs of the 3 obvious boxes on the right.
If you thinks you are going to need to do any kind of special formatting of your labels then on the Options tab check Synchronize. This enables you to make some change in the upper left label then pass that change to all other labels.
Labels is one area where you would do well to ignore OOo's help file.
To print your labels simply click the Print icon, answer "yes" to the "form letter" query and go from there.
This covers the basics. Ask for any other help you need.
See my comment in this thread. http://user.services.openoffice.org/en/ ... 828&p=3351
File > New > Database, bullet "Connect to existing database", set the drop down menu to Spreadsheet and complete the wizard.
Do the labels.
File > New > Labels. On the Labels tab your Database, Table(s) and field names will be available on the drop downs of the 3 obvious boxes on the right.
If you thinks you are going to need to do any kind of special formatting of your labels then on the Options tab check Synchronize. This enables you to make some change in the upper left label then pass that change to all other labels.
Labels is one area where you would do well to ignore OOo's help file.
To print your labels simply click the Print icon, answer "yes" to the "form letter" query and go from there.
This covers the basics. Ask for any other help you need.
See my comment in this thread. http://user.services.openoffice.org/en/ ... 828&p=3351