Merge: Can't just print out what is selected?

K

kevs1

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I am merging a letter with an Excel document. The excel file has 1000 names, but I only want to merge first 100 now. I tried selecting in Excel those first 100 rows, but it did not work. Word still merged all 1000 letters.
Anything I can do? thanks.
 
C

CyberTaz

What portion of the records are included in the merge isn't determined in
the record source. In step #6 of the Mail Merge Manager open the list that
currently reads "All", select Custom, then enter the range of records in the
value boxes that activate for that purpose.

Alternatively, use step #4 to filter for like record based on criteria.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
K

kevs1

Excellent Bob.
Interestingly, it works great when merged which is what counts, but in the preview (which I can now use because of you), it still show all 1000 still -- no big deal.

Did not understand #4 option at all -- that's the drag and drop into this document area?
 
C

CyberTaz

Excellent Bob.
Interestingly, it works great when merged which is what counts, but in the
preview (which I can now use because of you), it still show all 1000 still --
no big deal.

That's because the filtering isn't done until you actually do the merge. As
suggested in my reply to your recent post in the other thread the Preview is
provided as a convenience.
Did not understand #4 option at all -- that's the drag and drop into this
document area?

My mistake - I had 2008 in my mind & the Manager in 2004 doesn't use numbers
& is set up a bit differently - Sorry :-}

What I should have suggested is in the Merge group (last group) - Click
Query Options for the Filter/Sort features... the All list is there too &
works as advertised.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
K

kevs1

Thanks Bob, took a peek at query options. Have no idea what that does. Is it releated to this discussion?
 
C

CyberTaz

Not directly, but as an extension of it. Your original point was merging
based on sequential order of the records. The Query Options allow you to
sort the records in a different order & select records to be included based
on criteria. IOW, rather than just including the first 100 records in the
source you might prefer to merge records in which:

State = PA
City = Pittsburgh

And have those records Sorted in ascending order by Zip Code.

I was just pointing out alternatives :)

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top