View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cynthia Cynthia is offline
external usenet poster
 
Posts: 25
Default Dummy letters on mail merge

Thanks, but that didn't do it. I also tried setting the required records as
the print area on the spreadsheet, but that was also unsuccessful.

I'm wondering if there is a way to deselect the blank records as a group
when I preview the Recipients listing -- or deselect all records and select
the needed records as a group?
--
Cynthia


"Doug Robbins - Word MVP" wrote:

Select all of the rows in the Excel spreadsheet after the last record and
press Delete. There may be spaces in some of the cells in those rows that
are resulting in them being treated as records.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Cynthia" wrote in message
...
I am using Word 2003 SP2 and Excel 2003 SP2. I have 347 names and
addresses
on a spreadsheet as my database for my mail merge. When I merge
information
into the form letter, I end up with over 3,000 letters. The 347 I need
are
correct, but the others are blank or "dummy" letters. Right now, I am
manually deleting these letters after merging and before printing.

Is there a way to delete or avoid creating these dummy letters prior to
creating the merged letters?
--
Cynthia