[yclhk]

Dear Graham,

My MS Office ver is Word 2000. How can I work with this version ? And,
your help link provided is not worked.

Thnaks,

"Graham Mayor" wrote:

From the merge toolbar - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm select the Mail
Merge Recipients button. This will list all the records. It doesn't matter
whether they are sorted in Excel.

Click the tiny arrow in the header row against the Team column. This will
list the variables that column contains. Pick the team you want to print and
merge. Next from the same arrow select 'All', to display all the records
again, then select the next team. You should be able to merge each team
separately.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


yclhk wrote:
Dear Graham,

There are ten teams data in the Excel file and I hope to merge to
print the labels in ten seperate label sheets by each team. I worked
in the following ways but got the problem:

1) sorted the Excel file and made the data arranged by Teams A, B, C,
D...... 2) saved the Excel file and quited
3) merge to a Word file in form of labels layout
4) in the merge option select Team = A and print the sheet of Team A
and so on 5) I could work Team A, B, C, D, E however, while I
continued to merge Team F, G, H, it can't work and return with a
message that can't merge the empty data from source.

Does I work in the wrong way or the merge operation have the
limitation for something ?

Thanks again for your help,

yclhk

"Graham Mayor" wrote:

Word does not lend itself to this type of merge. The simplest
solution would be to merge each Team separately

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


yclhk wrote:
I wish to merge print a set of labels from the data in a Excel file.

The content of the exce file:

Name Address Tel Team
ABC House1 1234 A
BCD House2 2345 B
CDE House3 3456 C
DEF House4 4567 B
EFG House5 5678 A
FGH House6 6789 C

I merge the fields from the Excel file and print the labels in the
following form:

Name: ABC
Add: House1
Tel: 1234
Team: A

I wish to print the labels in the Team A, B and C in seperate
sheets, i.e the sheet Team A with the data of Team A ........ . I
can merge the data and print the all the labels in one sheet but
how can I print the labels in seperate sheet with data of Team A, B
and C ?

Thanks,