Mail Merge Question

JayVilla · General User Joined: 05 Oct 2005 Posts: 10

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

oojerre · General User Joined: 17 Nov 2004 Posts: 28

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.

JohnV · Posted: Thu Oct 27, 2005 4:33 am Post subject:

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.

JayVilla · General User Joined: 05 Oct 2005 Posts: 10

JohnV · Posted: Thu Oct 27, 2005 8:01 am Post subject:

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.