Can I print a sheet of different labels

Asked by Ada Campbell on 2010-12-18

From a Spreadsheet or database -
I want to print one sheet consisting of 21 different labels - one of each -
can this be done or do I need to print a full sheet of each entry .
I have followed instructions from earlier queries and get a full sheet of each label

Thanks
Ada

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2013-11-01
Last reply:
2013-11-16
Tony Pursell (ajpursell) said : #1

Hi Ada

You can print a sheet of different labels using mail merge (File > New > Labels). The Label Text field on the Labels dialogue can contain pure text (which will only give you one repeated label) or database field references, which will lead to a sheet of different addresses pulled in from the data base. Here is a question about labels where I gave instructions for printing labels from addresses held in a spreadsheet

https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/132897

Let me know if you want more help.

Tony

PS If this answers your question, please mark it as Solved

Ada Campbell (ahcampbell1a) said : #2

HI
Thanks for that -
I am sorry if I still cant get the hang of this
I need some help finding the database field references to put in to the
labels dialogue instead of pure text. - I had previously put in pure text
- as you identified. - where do I get the database field refs from ??
My data is in a spreadsheet - ods format -

Or what do I put in for spreadsheet references ?
Thanks
Ada

On Sat, Dec 18, 2010 at 11:51 AM, Tony Pursell <
<email address hidden>> wrote:

> Your question #138221 on openoffice.org in ubuntu changed:
>
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/138221
>
> Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Hi Ada
>
> You can print a sheet of different labels using mail merge (File > New >
> Labels). The Label Text field on the Labels dialogue can contain pure
> text (which will only give you one repeated label) or database field
> references, which will lead to a sheet of different addresses pulled in
> from the data base. Here is a question about labels where I gave
> instructions for printing labels from addresses held in a spreadsheet
>
>
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/132897
>
> Let me know if you want more help.
>
> Tony
>
> PS If this answers your question, please mark it as Solved
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/138221/+confirm?answer_id=0
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
>
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/138221
>
> You received this question notification because you are a direct
> subscriber of the question.
>

Tony Pursell (ajpursell) said : #3

Hi

You have to register your spreadsheet as a data base first. To do this:

- File > New > Database
- Click on 'Connect to an existing database' and select 'Spreadsheet' from the drop down list. Click Next >>
- Browse to your spreadsheet. Click Next >>
- Uncheck 'Open the database for editing'. Click Finish. You will be asked to save the Database definition file, You can give it the same name as your spreadsheet and OOo will add a .odb extension.

Now, back in the Labels dialogue, you will find it in the drop down list of Databases and be able to set up your label. Under Table, you will probably have Sheet 1. Then under Database Field you will have a list of Columns. Select the columns in the order you want them on the label and click the arrow to transfer them into the Label text box.

When you have done that, click New Document. You will get what I call a Merge Master. Then do File > Print. and select Yes in the dialogue that asks you 'Do you want to print a form letter'. This gives you a Mail Merge dialogue where you can do all sorts of things. I will leave you to explore, but for now click on File for the Output, then OK. You will be asked to save a document containing the labels. I would also suggest your save the Merge Master document because you can open it and do File > Print any time you want these labels again.

Just one tip, before I finish. Print your labels on plain paper first and check the registration with the actual labels sheet. I find sometimes the lines are too tight to the left and need to be spaced in a bit.

Tony

Tony Pursell (ajpursell) said : #4

I have also set up a FAQ for this question.
FAQ #1433: “How do I print Labels from data in a speadsheet?”.

Ada Campbell (ahcampbell1a) said : #5

Check out this property, Click
here<http://projects.eecsa.kz/wp-content/realestate/realestate.htm>and
login with your email.

Launchpad Janitor (janitor) said : #6

This question was expired because it remained in the 'Open' state without activity for the last 15 days.