Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

Difficulty merging from Excel to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Russ - 29 Dec 2005 21:51 GMT
This is a recurrent problem. When attempting to select mail merge recipients,
I get either "Word could not parse your query options into a valid SQL
string" or "Word could not merge the main document with the data source  
because the data records were empty or no data records matched your query
options"

I know the latter is wrong, as when looking at the data I can SEE at least
one item that matches my query options.

As I know next to nothing about SQL, or what Parsing might be, I don't know
where to proceed from here.

From my research, I know that apostrophes and wild cards can cause problems
with merging. We use niether here.

Any help will be appreciated.
Graham Mayor - 30 Dec 2005 07:15 GMT
See if - http://support.microsoft.com/?kbid=825765 helps.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> This is a recurrent problem. When attempting to select mail merge
> recipients, I get either "Word could not parse your query options
[quoted text clipped - 12 lines]
>
> Any help will be appreciated.
Russ - 30 Dec 2005 15:16 GMT
I followed the instructions in the link you supplied, and while it worked as
far as removing the introductory dialogue box, it didnt resolve my original
problem. Even with the changes in place, I'm still having issues getting Word
to merge in certain circumstances.

Here's a little additional information:
We're attempting to print form letters, filtering by letter date and letter
type. This throws up an error. If I filter the same information by letter
type and then letter date, it seems to work just fine. The only difference I
can tell between the two methods is that when sorting by date, you have to go
into the advanced filter panel and type in the date, whereas the other method
is accomplished through only drop-down menus.

Thanks again

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.