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,