word could not parse your query option into a valid SQL string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kirk - 19 Jan 2004 09:53 GMT

When trying to mail merge using the query option I keep
getting this message "word could not parse your query
option into a valid SQL string". It is only ever on the
one field, in which some entries are just letters,
e.g. "ISTD Inter", and other entries are letters and
numbers, e.g. "Gr 2". This has really got me stumped and I
could really do with some help!

kirk

Reply to this Message

Cindy M -WordMVP- - 19 Jan 2004 19:03 GMT

Hi Kirk,

> When trying to mail merge using the query option I keep
> getting this message "word could not parse your query
> option into a valid SQL string". It is only ever on the
> one field, in which some entries are just letters,
> e.g. "ISTD Inter", and other entries are letters and
> numbers, e.g. "Gr 2".

Which version of Word is this? What's the data source?

When this happens to me, the most usual cause is that the
field name isn't being processed correctly. Like, it might
contain a space or some other character Word isn't able to
handle. Does the field name in the Query Options list look
exactly like what's presented in the list of fields? And
how do these compare to the actual field name in the data
source?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message