I am trying to mailmerge using an external (web based) xml source.
I am using


objWordDoc.MailMerge.OpenDataSource("http://myservername/mailmerge/getdata.php", 'wdOpenFormatXML');
The test program getdata.php returns a valid XML file.

I know that in early threads, this was not possible, but thought that as the years had progressed, so might the interface.

Is there a way of reading remote XML (or CSV for that matter) files and using them in mailmerge?

Any help would be appreciated.

Since you're using code, why not simply copy the files to a local folder and use them from there? http://myservername/mailmerge/getdata.php is not a reference to an XML-format file - it's a php reference. The php reference can probably be processed via an IE automation; otherwise, you should use the link to the actual file.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The php file DOES create an XML file format output and will control the security access to the data. I do not want to give users FTP or other forms of access to the data.

In 2014 it seemed a reasonable request to be able to mailmerge centrally controlled data into a local word document at the click of a button.