MS Word - OpenDataSource issues

[Andy007]

Hi All,

I am finding my word merge program is caching my datasource and my autoit program is not overriding this cached value.

Here is a few lines from my autoit program to reset the datasource:

$mm = $wd.Activedocument.MailMerge

$mm.OpenDataSource ('"' & $data & '"', 0, true, true, true, false, "", "", false)

Where $wd is my word object and $data is my new csv data file.

Any help would be greatly appreciated.

Word2003/2007+WinXP/Vista

[StSchnell]

Hello Andy,

is it possible that Word hold the connect to the source and your program want to change it?

Try the command

Word.Application.Activedocument.MailMerge.MainDocumentType = wdNotAMergeDocument

to close an open connection.

Hope it helps.

Cheers

Stefan

P.S. wdNotAMergeDocument = -1

[Andy007]

Thanks Stefan,

Did not work for me... I tried about 10 variations but no good.

Any other ideas?

[Andy007]

Does anyone else have this problem, or am I alone... All alone. . .

[Andy007]

I think I have it working now.

I had to re-install MS Office.