[Kathy]

Data in excel, workbook with multiple sheets. Monthly I do a merge (letter
or labels) with current sheet entering data on. In word when connecting to
data file, use an existing list, browse, choose data, select which sheet to
work with in workbook, window mail merge receipients comes up, I then check
the people to merge.

Other times, after selecting worksheet in workbook, I get a window "select a
table". when I highlight workbook: c:/documents.... the cancel key in the
window will highlight and does nothing. I have copied data to a sheet that I
can merge with and that works generally, but need to see what is causing this
glitch i.e. permission, options, etc.

[Peter Jamieson]

Responded in the mailmerge.fields group.

Peter Jamieson
"Kathy" wrote in message
...
Data in excel, workbook with multiple sheets. Monthly I do a merge
(letter
or labels) with current sheet entering data on. In word when connecting
to
data file, use an existing list, browse, choose data, select which sheet
to
work with in workbook, window mail merge receipients comes up, I then
check
the people to merge.

Other times, after selecting worksheet in workbook, I get a window "select
a
table". when I highlight workbook: c:/documents.... the cancel key in
the
window will highlight and does nothing. I have copied data to a sheet
that I
can merge with and that works generally, but need to see what is causing
this
glitch i.e. permission, options, etc.