Hi,

I have a MySQL database which contains customer data. I have written a PHP
script to create a CSV file and then import the data into Microsoft excel
using COM, which has been saved into C:\TEMP\test.xls. I am now trying to
start a mail merge in word with the following code:-

com_load_typelib('Word.Application');

$word = new COM("word.application") or die("Unable to instantiate Word");
$word->Visible = 1;
$word->Documents->Add();
$word->ActiveDocument->MailMerge->MainDocumentType = wdFormLetters;
$word->ActiveDocument->MailMerge->OpenDataSource _("c:\\temp\\test.xls");

I only want to setup the mail merge up to the point where the user can start
selecting fields.

The problem is that after word opens it prompts me to select a table.
According to the Microsoft documentation this is because the SQLStatement
parameter has not been specified in the call to OpenDataSource.

I have created a empty variant data type as follows:-

$empty = new VARIANT();

and used it in the new call where
OpenDataSource
("c:\\temp\\test.xls",$empty,$empty,$empty,$empty, $empty,$empty,$empty,$empt
y,$empty,$empty,$empty,"SELECT * FROM test$",$empty,$empty,$empty);

When I run the script I get the following error:

Warning: (null)(): Invoke() failed: Type mismatch. Argument: 17 in
c:\program files\apache group\apache\htdocs\test6.php on line 93

I didn't think I had specified 17 arguments.

I have checked want data types OpenDataSource is expecting and according to
OLE/COM view it is expecting a BSTR followed by 15 optional variants.

I apologise if this seems like a stupid question but I've only been
programming in php for a couple of months. Any advice would be appreciated.

Thanks
Dave