[thelist] mysql to ms word for merge letter

[Joe Crawford]

Adrian Fischer wrote:
> Thought it would be worth asking before I try and do it myself....has anyone
> done anything like getting the names and addresses etc from a mysql db and
> saving them into a delimited file for use in a ms word document as a   merge
> file?
> 
> Just thought Id ask...tips..pointers...code ;-)

I have 2 parts of the equation, maybe...

I have created explicit CSV output pages with PHP+MySQL, saved them, then
imported them into the Word for Mac ('98). I have added MySQL datasources
with the MySQL ODBC Driver to a WinNT box.

*Theoretically* you should be able to:
    - add an ODBC driver for MySql to your Windows box
    - use that as a datasource for your merge file
      (Windows help was pretty clear on how to use merged
       data, I'd read that part of the help section *carefully*)

I got the mysql odbc drivers from the mysql site --
http://www.mysql.com/downloads/api-myodbc.html

Best,
    Joe <http://artlung.com/>
--
Joe Crawford ||||||||||||||       mailto:jcrawford at avencom.com
||||||||||||||||||||||||             http://www.avencom.com
|||||||||||||||||||||||||||      Avencom: Set Your Sites Higher