Hello !
I got MS Query working, but only in interactive mode.
I tried to record the Word activities to following makro:
-----snip --- snap -----
ActiveDocument.MailMerge.OpenDataSource Name:="", ConfirmConversions:= _
False, ReadOnly:=False, LinkToSource:=False,
AddToRecentFiles:=False, _
PasswordDocument:="", PasswordTemplate:="",
WritePasswordDocument:="", _
WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto,
_
Connection:= _
"DSN=rasql;DB=rasql;SERVER=www.fds.local;UID=avani;PWD=avani;PORT=;OPTION=16
384;STMT=;" _
, SQLStatement:= _
"SELECT adressen_0.adrnr, adressen_0.searchfield, adressen_0.name,
adressen_0.name1, adressen_0.strasse, adressen_0.plz, adressen_0.ort,
adressen_0.postfach, adressen_0.plzpostfach, adressen_0.telefon1,
adressen_0.telefon2, adressen_0.telefon3, adressen_0." _
, SQLStatement1:= _
"telefon4, adressen_0.telefon5, adressen_0.ansprechcode,
adressen_0.ansprechname, adressen_0.vorname, akten_0.intref, akten_0.akte,
akten_0.sb, beteiligte_0.intref, beteiligte_0.adrnr, beteiligte_0.typ,
beteiligte_0.typindex FROM adressen adressen_0, akte"
-----snip --- snap -----
But it does not work. I always get the error 5922, Word could not open
Datasource.
can anybody help?
rgds, Felix.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php