Mail Merge Selecting ALL records in Excel instead just row..

pctrainer98 · External Since: May 04, 2010 Posts: 1

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 · External Since: Sep 26, 2003 Posts: 24483

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

"pctrainer98" wrote in message

> 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 · External Since: Sep 26, 2003 Posts: 24483

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

"Suzanne S. Barnhill" wrote in message

> 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
>
> "pctrainer98" wrote in message
>
>> 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!
>>
>
>