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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kesh - 17 May 2005 05:25 GMT

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

Reply to this Message

Peter Jamieson - 20 May 2005 12:59 GMT

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

>I want to use xml file as a datasource of mail merge.. following is a
>sample
[quoted text clipped - 14 lines]
>
> Kesh Patel

Reply to this Message