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