Is there any way that you can pass variables to MS Word through the URL or any way so that I can take data from a mySQL database and Mail Merge it?
Thanks in advance, Tommy
What is your final goal? Do you really need to go through such crooked paths, ie, make information from mySQL go through MS Word, to achieve what you want, which I suppose is just send mail?
Luciano ES Santos, SP - Brasil
My final goal is to make a document that a reseller can print and give to a customer. Currently we are using PDF/FDF. Mail Merging is much easier to setup form field-wise, plus with a PDF you can only do one set of documents at a time. Currently to do a Mail Merge we have to get the data into a CSV format and merge it manually, which is a long process.
You can connect to the mysql via ODBC from Word , add some labels or fields to your document and bind them to the column fields you want. It's a good an easy way. See more on data binding at Microsoft. Hope to help.
Hi,
I think it should be possible using PHP and COM. But my personal experience with COM thru PHP is that one requires a lot of trial and error. Things don't work the way they are supposed to.
Nilesh
