Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham in Sussex Graham in Sussex is offline
external usenet poster
 
Posts: 1
Default using mail merge from Excel cuts off after 70 records

I have an Excel file with 75 records but when I try to mail merge it in Word
it cuts off after 70 records. If I sort the fiel so the missing records are
at the beginning it does the same thing - the last 5 records are omitted in
the mail merge. Any idea why please? I'm using Office 2007.
Thank you.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default using mail merge from Excel cuts off after 70 records

Can we assume that you are "completing the merge", e.g. if you happen to be
using a lable layout with 70 labels per page, you will only see the first 70
records until you merge to a new document or to a printer?

Assuming that we can...

When you connect to your data source, you should see a list of "tables."
Usually there will be one table for each sheet in your workbook. But if you
have created a range name that happens to "cover" 70 records, that will be
listed as well: if you sort the records in the /worksheet/, the range name
will still only "cover" the first 70 records.

Well, that doesn't sound too likely either. Other things to look out for are
empty rows and hidden rows (although I would have thought that your "sort"
experiment would have revealed those kinds of problem)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Graham in Sussex" Graham in wrote in
message ...
I have an Excel file with 75 records but when I try to mail merge it in
Word
it cuts off after 70 records. If I sort the fiel so the missing records
are
at the beginning it does the same thing - the last 5 records are omitted
in
the mail merge. Any idea why please? I'm using Office 2007.
Thank you.


Reply
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
Mail merge cuts off some text, how do i fix this? k&p Microsoft Word Help 3 May 4th 23 08:47 AM
Slow moving through records in Mail Merge linking with Excel Jo Mailmerge 0 May 23rd 08 10:28 AM
Word 2003 SP2: Missing records in mail-merge from Excel to directory Bill Davy[_2_] New Users 6 August 14th 07 08:02 AM
merge records are using too many decimal spaces when I use records from an Excel Database aspen Mailmerge 1 March 23rd 07 09:12 PM
Combine Mail Merge records when different records have 1 common fi TFFAV Mailmerge 1 December 12th 06 11:56 PM


All times are GMT +1. The time now is 12:07 AM.

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

About Us

"It's about Microsoft Word"