[Curt]

not familar. is it possible to have word check an entry in excel say A:1 if
x in cell merge data specified in that row. if blank skip the row. without
feeding paper when skipping rows. one post said you would get blank sheets
when doing a similar execution. Have not done merge to be knowledgeable.
Thanks

[Peter Jamieson]

In theory you should be able to do that by opening the Mail Merge Recipients
dialog box (I'm assuming you're using Word 2002/2003) and using the
drop-down in the label at the top of the column (let's assume the column is
called "Selected") to select only the rows where the value is "x" (be
careful about upper/lower case). Or use the Advanced... option in that
drop-down to go to a "Query options" dialog where you can specify the same
thing in a different way.

I say "in theory" because there can be problems with selections with some
data sources. But try that and see if it does what you need.

Peter Jamieson
"Curt" wrote in message
...
not familar. is it possible to have word check an entry in excel say A:1
if
x in cell merge data specified in that row. if blank skip the row. without
feeding paper when skipping rows. one post said you would get blank sheets
when doing a similar execution. Have not done merge to be knowledgeable.
Thanks

[Curt]

Thanks for the heads up


"Peter Jamieson" wrote:

In that case you have to use the Mail merge Helper, then Query Options.

Peter Jamieson
"Curt" wrote in message
news
No I am useing 2000 Will look for same feature hopefully
Thanks
Curt

"Peter Jamieson" wrote:

In theory you should be able to do that by opening the Mail Merge
Recipients
dialog box (I'm assuming you're using Word 2002/2003) and using the
drop-down in the label at the top of the column (let's assume the column
is
called "Selected") to select only the rows where the value is "x" (be
careful about upper/lower case). Or use the Advanced... option in that
drop-down to go to a "Query options" dialog where you can specify the
same
thing in a different way.

I say "in theory" because there can be problems with selections with some
data sources. But try that and see if it does what you need.

Peter Jamieson
"Curt" wrote in message
...
not familar. is it possible to have word check an entry in excel say
A:1
if
x in cell merge data specified in that row. if blank skip the row.
without
feeding paper when skipping rows. one post said you would get blank
sheets
when doing a similar execution. Have not done merge to be
knowledgeable.
Thanks

[Curt]

I goofed up I guess. Was trying to do merge said file was read only open it
for editing. I did. Columns apeared as in excel sheet. Now I cannot open the
excel file as befor. What do I do??? Found a good book to day that got me
into this fix.
Thanks

"Peter Jamieson" wrote:

In that case you have to use the Mail merge Helper, then Query Options.

Peter Jamieson
"Curt" wrote in message
news
No I am useing 2000 Will look for same feature hopefully
Thanks
Curt

"Peter Jamieson" wrote:

In theory you should be able to do that by opening the Mail Merge
Recipients
dialog box (I'm assuming you're using Word 2002/2003) and using the
drop-down in the label at the top of the column (let's assume the column
is
called "Selected") to select only the rows where the value is "x" (be
careful about upper/lower case). Or use the Advanced... option in that
drop-down to go to a "Query options" dialog where you can specify the
same
thing in a different way.

I say "in theory" because there can be problems with selections with some
data sources. But try that and see if it does what you need.

Peter Jamieson
"Curt" wrote in message
...
not familar. is it possible to have word check an entry in excel say
A:1
if
x in cell merge data specified in that row. if blank skip the row.
without
feeding paper when skipping rows. one post said you would get blank
sheets
when doing a similar execution. Have not done merge to be
knowledgeable.
Thanks