Hi Butch,
> I included the links to MySQL.com for the ODBC Drivers (Win2k/XP or Win98). > I am running Win2k and XP Pro so I know it works well with them. > Make sure you run setup.exe from the directory you unzipped the files. > The last step for install on the ODBC is setting up a DSN: > Next we need to see if you have MSQuery installed... if you do the file name > is MSQRY32.EXE in your Office directory. (Check) I have got this all... > Start Word > from a blank new document go to Tools -> Mail Merge > Click Create ->Form Letter > Click Get Data ->Open Data Source > Click MS Query (Alt+Q) > Select my_odbc_test from the list > Select the data tables to grab data from MySQL > Select conditions to select the data and the sort order > Select Return Data to MS Word That's the way it works fine for me also, but i cannot automate this in a macro? Perhaps I cannot start MS Query from the macro, or at least I do not know how to ? > > There will now be a new toolbar in Word > Use the Insert Merge Field button to add MySql fields to your document. > The button next to Insert Word Field will toggle data view over field view > (try it after adding a merge field to the document) usual stuff... okay, > ODBC Win98 > http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-win95.zip > ODBC WinNT/XP > http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-nt.zip great stuff, I downloaded it about 2 months ago... > > Mail Merge Stuff for Word and VBA > http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartI.asp > http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartII.asp This is really new to me, I will check this out today ! Thanks a lot Butch ! greets, 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
