>> xsql = "SELECT * FROM `spec` where cuniqcode =' 3008'"
>> ActiveDocument.MailMerge.DataSource.QueryString = xsql
If I set my datasource from the menu everything works. I can step
through all records and view them in the mailmerge document one at a
time.
Once I execute the query string, it displays the record found, and
then save the document, when I open again I get the Find Data Source
cannot be found message.
How can I execute automatically a macro to position to display the
correct record in my database without getting this message.
Thanks
Cindy M -WordMVP- - 21 Aug 2004 12:12 GMT
Hi ImOkYoureNot,
Which version of Word are we discussing, here? And what connection
method has been used to link it in?
> >> xsql = "SELECT * FROM `spec` where cuniqcode =' 3008'"
> >> ActiveDocument.MailMerge.DataSource.QueryString = xsql
[quoted text clipped - 9 lines]
> How can I execute automatically a macro to position to display the
> correct record in my database without getting this message.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)