[thelist] mysql to ms word for merge letter

[Adrian Fischer]

Thanks Joe...does it matter that my db is hosted somewhere else?

*Theoretically* are you saying I can use the ODBC to dynamically link my
word document on my win_pc to my db on the internet (I have  permanent cable
connection) or was that just wishful thinking on my part? Or are you saying
I can create a CSV file on the server then link to that...am I sounded as
though I don't know what I'm talking about (for very good reason)? If so
would there be any chance of taking a peek at he php you used?

Thanks

Adrian Fischer




> 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/>