Excel for MAC 2011 + Word 2011 Mail merge limits?

[stuartpage]

Hi all

Really odd problem with Mac Excel 2011 and Word 2011

I (my wife) have an Excel file with approx 5000 rows of records in it. All rows have something in, no blank rows.

When running a Mail Merge, it will only display 950 records not the full 5000.

Running with a test file of 3500 records in Excel 2010/Word 2010 on Windows 7 gives out all 3500 records.

Surely the MAC version can handle more than 950 records?

Any advice/help on this would be greatly appreciated.

The IT helpdesk at my wifes place of work just shrugged shoulders and said "well we can get you a Windows machine to run this on if you want"

 

[Jim Gordon]

Look at the record where the import stops and see if there is bad data or a hidden character that acts to stop the import.

 

[RoryA]

You can also simply move that row to the start of the data and see if it fails earlier. If so, you know it's data-related.