How to use xml file as data source for Mail merge?

[Kesh]

I want to use xml file as a datasource of mail merge.. following is a sample
xml file.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<address>
<name>ABC Pty Ltd</name>
<address1>18-Victoria Street</address1>
<city>Burwood</city>
<state>NSW</state>
<postcode>2134</postcode>
</address>

Thank you for your help.

Best regards

Kesh Patel

 

[Peter Jamieson]

Unfortuantely you cannot use it directly, but if you have Excel 2003 (and
perhaps earlier, I do not know) you can open it in that program, save it as
a .xls, and merge that. If you have Access 2003, you could do something
similar. There are other ways you could potentially transform a .xml file
for use as a merge data source but that's probably the simplest.

Peter Jamieson