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

Mail Merge Question

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


Joined: 05 Oct 2005
Posts: 10

PostPosted: Wed Oct 26, 2005 7:27 pm    Post subject: Mail Merge Question Reply with quote

Hello to all.

I'm currently trying to create a request book using a database with Title and Artist fields.

When I enter these fields into a table I created in writer, the same artist and title are repeated again and again on the page, and writer wants to print a whole page for each entry in my database (over 10,000 songs).

If I choose to print labels, this does not happen. Each label will have an individual title and artist on each. I can get several titles and artists on a page, but it I do not want to print labels. Can anyone help? I can email you the files if you need.

Thanks a million.

Jay
Back to top
View user's profile Send private message
oojerre
General User
General User


Joined: 17 Nov 2004
Posts: 28

PostPosted: Wed Oct 26, 2005 9:23 pm    Post subject: Reply with quote

You need to insert the Field NextRecord at the end of each of your records in the table, except for the very last one on the page, because a page break does a NextRecord anyway. If you check the View Fields on your label docuents, you'll see this is how it works.
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


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

PostPosted: Thu Oct 27, 2005 4:33 am    Post subject: Reply with quote

You may also want to try listing your records by pressing F4 in your doc, opening your table in the db viewer, selecting all or some records and then clicking the Data to Text icon which will give you 3 options for displaying the chosen records.

Although you only have 2 fields and probably want to display both, this method does allow you to control what fields are displayed and their order.
Back to top
View user's profile Send private message
JayVilla
General User
General User


Joined: 05 Oct 2005
Posts: 10

PostPosted: Thu Oct 27, 2005 6:40 am    Post subject: Reply with quote

oojerre wrote:
You need to insert the Field NextRecord at the end of each of your records in the table, except for the very last one on the page, because a page break does a NextRecord anyway. If you check the View Fields on your label docuents, you'll see this is how it works.


Thanks! That is what I needed. Now I have another small problem.....

The records go from left to right in order, not from top to bottom. Can this be changed?

I have 4 colums. Artist / Title / Artist / Title

The order is like this:
Record 1 Artist / Record 1 Title / Record 2 Artist / Record 2 Title
Record 3 Artist / Record 3 Title / Record 4 Artist / Record 4 Title

instead of this which I want:
Record 1 Artist / Record 1 Title / Record 3 Artist / Record 3 Title
Record 2 Artist / Record 2 Title / Record 4 Artist / Record 4 Title
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


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

PostPosted: Thu Oct 27, 2005 8:01 am    Post subject: Reply with quote

Using the method I suggested you can do this using any of the available options and setting your Page style to 2 columns.

I think you are doing at lot of work to do something OOo will do for you without the work.
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 Writer 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