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
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
> 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 - 13 Feb 2007 23:29 GMT
No I am useing 2000 Will look for same feature hopefully
Thanks
Curt
> 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
[quoted text clipped - 14 lines]
> > when doing a similar execution. Have not done merge to be knowledgeable.
> > Thanks
Peter Jamieson - 14 Feb 2007 01:07 GMT
In that case you have to use the Mail merge Helper, then Query Options.
Peter Jamieson
> No I am useing 2000 Will look for same feature hopefully
> Thanks
[quoted text clipped - 25 lines]
>> > knowledgeable.
>> > Thanks
Curt - 14 Feb 2007 06:00 GMT
Thanks for the heads up
> In that case you have to use the Mail merge Helper, then Query Options.
>
[quoted text clipped - 28 lines]
> >> > knowledgeable.
> >> > Thanks
Curt - 15 Feb 2007 01:26 GMT
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
> In that case you have to use the Mail merge Helper, then Query Options.
>
[quoted text clipped - 28 lines]
> >> > knowledgeable.
> >> > Thanks