Word/Excel 2000 Mail Merge Error

  Sir Radfordin™ 12:59 21 Feb 03

Any ideas on this one?

Trying to do a mail merge from Excel into Word. There are two query options that have to be selected. When doing this however it gives this error message:

"word could not parse your query options into
valid SQL string"

Which doesn't mean much to me, and I can't find anything out about it (apart from for a Mac!)

I know its not the PC because I've tried it on 3 and so guess its perhaps the worksheet. Problem is that the same query with different variables works!

  jazzypop 15:15 21 Feb 03

The (very) general answer is that when doing this sort of mail-merge, Office creates an internal database to construct the table from which it can extract the required records (from Excel).

It then applies an SQL query, which it creates according to the queries and values.

There is a problem with either the query, or more likely one of the values in the worksheet, which means that during the internal construction phase, an invalid SQL command or parameter is created.

Try using the first half of the Excel sheet only, see if it runs OK, then do the same with the second half of the Excel records. If only one half of the values returns an error, then take that half and repeat the process, using half the records, until you find the record that is causing the difficulty.

There is also the possibility that that SQL parser is getting confused by the formatting applied to the cells, and is treating numbers as text, or vice versa.

To work around this, try exporting the Excel sheet to a .csv file (which will strip out any Excel-specific formatting), and try the mail-merge using the .csv file as the source.

It will obviously be quicker to try this before the 'hunt the record' approach that I suggested above :)

  Sir Radfordin™ 16:55 21 Feb 03

Just run some tests on different things, and it looks like there is something on the 5 rows that is causing a problem. Can't work out what or why though!

Have suggested the user recreates those rows to see if the problem still exisits.

This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…