OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Printing Labels from spreadsheet data

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
LeighM
General User
General User


Joined: 03 May 2005
Posts: 8
Location: Adelaide, Australia

PostPosted: Wed Jun 28, 2006 6:22 am    Post subject: Printing Labels from spreadsheet data Reply with quote

That says it, really. I have a sheet, each row is one name, address, etc. I want to print lables based on this data.

How can I print this data onto A4 label sheets?

I've looked in Help, and can see how if I was to start again and build a data base.

Maybe a 3rd party prog?

I would appreciate a note if you can spare a thought.

Leigh
Back to top
View user's profile Send private message Send e-mail
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Jun 28, 2006 7:25 am    Post subject: Reply with quote

First, in the first row of the spreadsheet add field names like Name, Address, etc. if not already there and save. Do File > New > Database. Select "CONNECT to exiting database" and select Spreadsheet in the drop down menu. On the next screen you can browse to the file and click Finish. You have just registered a new data source with OOo.

Now when you do File > New > Labels this data source and its data will be available in the Database, Table & Field boxes for your use.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Jun 28, 2006 7:30 am    Post subject: Reply with quote

This is what I would try:
Save your spreadsheet
File>New>Database
Wizzard step 1: open existing database, type: Spreadsheet
Wizzard step 2: point to your spreadsheet.
In the new database (which is a read-only datasource unless you edit the spreadsheet itself):
Notice which tables have been created from sheet-contents and named database-ranges.
Section "Reports": create new Report ...
Go through the steps of the wizzard. At the last step choose option: "Edit layout"
Editing the layout (page style) of the report, which is an ordinary writer document with linked database fields is beyond my knowlege. But you may find existing solutions at
http://ooextras.sourceforge.net/downloads/labels/
http://documentation.openoffice.org/HOW_TO/index.html
There is a chapter "Creating and Printing Labels and Business Cards......" in
http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf
http://documentation.openoffice.org/Samples_Templates/index.html
The data of the odb-document come from your spreadsheet, which should not move. The writer-report is embedded within the odb-document, but you can save it as a standalone writer document.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group