[yclhk]

Hi, Graham, thanks again.

I've worked in the following way to solve the problem:
- use auto filter in the excel file and sorted the expected Team by click
the small arrow;
- then merge the fields in Word and set the query to the desred Team

Anyway, thanks,

"Graham Mayor" wrote:

If anything it is easier in Word 2000 as you can use the query options of
the mail merge helper to choose the records.

--

Graham Mayor - Word MVP

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


yclhk wrote:
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,