Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2006

Tip: Looking for answers? Try searching our database.

Excel Records are selected but ALL blank records are merged

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
creekmdm - 25 Apr 2006 08:18 GMT
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 spreadsheet.  I have 60 or so names and addresses in the spreadsheet,
but the spreadsheet 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 spreadsheet, so
I'm left with the 60 perfectly merged envelopes I want plus 64,940 blank
envelopes.  What am I doing wrong?  Please help!!  
Peter Jamieson - 25 Apr 2006 11:37 GMT
Have you tried:
a. Excel Edit|Goto|Special|Last Cell to see where Excel thinks the last
cell in the sheet 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 sheet.

Peter Jamieson
>I am a novice, at best, with Mailmerge and Excel, and have run into a
>problem
[quoted text clipped - 13 lines]
> I'm left with the 60 perfectly merged envelopes I want plus 64,940 blank
> envelopes.  What am I doing wrong?  Please help!!
creekmdm - 26 Apr 2006 01:50 GMT
Thanks for the suggestion.  It didn't quite work though.  It showed the
65,334th cell as the last one, but I couldn't find any text in there and,
even after clearing everything, it still showed the 65,334th as the last
cell.  I just gave up and copied my relevant data into a whole new spread
sheet and its all working fine now!

> Have you tried:
>  a. Excel Edit|Goto|Special|Last Cell to see where Excel thinks the last
[quoted text clipped - 22 lines]
> > I'm left with the 60 perfectly merged envelopes I want plus 64,940 blank
> > envelopes.  What am I doing wrong?  Please help!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.