mail merge

[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]

No I am useing 2000 Will look for same feature hopefully
Thanks
Curt

 

[Peter Jamieson]

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

Peter Jamieson

 

[Curt]

Thanks for the heads up

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

Peter Jamieson

 

[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