Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
creekmdm
 
Posts: n/a
Default Excel Records are selected but ALL blank records are merged

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!!
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing selected pages of a merged document Andrew Mailmerge 2 March 23rd 06 07:28 PM
Help! Mailmerge code for all selected records? Kara Mailmerge 1 October 12th 05 07:05 PM
How do you add pages or records to a merging document? Excel to W Vickie Mailmerge 1 March 31st 05 08:06 AM
Merged document results in blank paper - why? Hils Mailmerge 1 December 14th 04 12:57 AM
Does anyone know how to include blank records from an Excel datab. Sandy Rung Microsoft Word Help 1 November 30th 04 06:33 PM


All times are GMT +1. The time now is 02:08 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"