Mail Merge Selecting ALL records in Excel instead just rows select

[pctrainer98]

We have had this problem several times and I cannot find a solution. We will
open a mail merge Word document that is connected an Excel Workbook.
Periodically it will select ALL of the records even though we go through and
select just the rows we want. No amount of filtering changes this problem.

We have tried re-saving both the word and excel docs, removing the excel doc
from the word doc and re-attaching.

Help!

 

[Suzanne S. Barnhill]

I'm wondering if you're being misled by the dialog you get when you click
Merge to New Document. Even when you have checked off specific records in
the Mail Merge Recipients dialog, the default setting in the merge dialog
(I'm not sure what the title of the dialog is) is "All." That just means
that you want to include all records rather than a specific range, but you
will still get only the records you have selected.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Suzanne S. Barnhill]

Okay, just ran a merge and it's the Merge to New Document dialog, and the
choices are "All," "Current record," and From x to x (to select record
numbers).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org