Word/Excel 2000 Mail Merge Error

  Sir Radfordin™ 12:59 21 Feb 2003
Locked

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 2003

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 2003

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.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Artist Pete Oswald on creating relatable characters & his new book

New iMac Pro release date, UK price & specs rumours

Idées cadeaux pour geeks et tech addicts