[thelist] mysql to ms word for merge letter
Joe Crawford
jcrawford at avencom.com
Wed Apr 18 04:19:05 CDT 2001
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
More information about the thelist
mailing list