Re: Excel Records are selected but ALL blank records are merged

Have you tried:
a. Excel Edit|Goto|Special|Last Cell to see where Excel thinks the last
cell in the *** is?
b. Selecting the entire apparently blank area below your data (from column
A to IV) and using Edit|Clear|All ? (I expect there's an easier way to do
this but I'm only a casual Excel user). Then try reconnecting from Word to
the ***.

Peter Jamieson
"creekmdm" <creekmdm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CAC3EDD0-48CB-499E-B0E5-8CD5A8A8DE8C@xxxxxxxxxxxxxxxx
I am a novice, at best, with Mailmerge and Excel, and have run into a
problem
that is driving me crazy. I am trying to create envelopes using data from
an
Excel spread***. I have 60 or so names and addresses in the
spread***,
but the spread*** itself still shows about 65,000 rows. In Mailmerge,
when
I'm prompted to select recipients, I uncheck all (because all 65,000 some
odd
entries are selected, regardless of whether or not there is any data in
the
fields) and then select the 60 or so with data that I want to merge. When
I
go merge, though, it merges all 65,000 rows from the Excel spread***, so
I'm left with the 60 perfectly merged envelopes I want plus 64,940 blank
envelopes. What am I doing wrong? Please help!!


.

Loading