Reply
 
Thread Tools Display Modes
  #1   Report Post  
JerryF
 
Posts: n/a
Default Multiple sets of data

I make sets of labels every so often at work, with information from a data
source that changes each time I make the sets.

What I'd like to do is make 5 sets of labels using mail merge.

There are 8 records in the data source. The label sheet is 4 columns, 20
rows.

An example result of one label page would be:

1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord

Using the label feature works fine, except I only get 1 set on a page of
labels. I see that the Next Record field is used. Is there a field to
bring it back to the 1st record?
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

To get that layout, you are going to need to create a datasource that
contains five sets of the data. That could be done fairly easily, but
admitedly with a bit of manual work by first creating a Catalog or Directory
type mailmerge in which you have the mergefields in the cells of a one row
table. Execute that merge and then copy and paste all of the rows four
times so that there are five sets of the data, then insert a row at the top
of the table and enter the mergefield names into its cells. Then save and
close that document and use it as the datasource for your label mailmerge.

Or, it maybe easier to execute the label merge to a new document, then copy
and paste the labels to fill up the page.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"JerryF" wrote in message
...
I make sets of labels every so often at work, with information from a data
source that changes each time I make the sets.

What I'd like to do is make 5 sets of labels using mail merge.

There are 8 records in the data source. The label sheet is 4 columns, 20
rows.

An example result of one label page would be:

1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord
1stRecord 2ndRecord 3rdRecord 4thRecord
5thRecord 6thRecord 7thRecord 8thRecord

Using the label feature works fine, except I only get 1 set on a page of
labels. I see that the Next Record field is used. Is there a field to
bring it back to the 1st record?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple sets of page numbers Jerry Microsoft Word Help 6 February 22nd 07 09:11 AM
multiple docs, one data source kp Mailmerge 12 January 31st 05 04:41 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM
can I merge two sets of address data in Word Mail merge kenben Mailmerge 1 December 4th 04 04:01 PM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 07:15 PM


All times are GMT +1. The time now is 05:43 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"