View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andrew Kennard[_2_] Andrew Kennard[_2_] is offline
external usenet poster
 
Posts: 19
Default Word2003 XML as data source ?

Hi

I'm trying to use an XML file as a data source for mailmerging in Word 2003

However When I try and open it via the datasources button it does not open
it and asks me what is it delimited by !

Ultimately I want to automate this via COM from another application and have
done this so far using CSV files which works fine

When I use the OpenDataSource method I am passing wdOpenFormatText to it

As there is a wdOpenFormatXML I assumed I could use an XML file ?

However as I cant seem to get this to work 'manually' as a user ?

What am I missing ?

I need to use XML files to get over quote and comma problems. I also have a
large description field I wish to use. I had considered automating excel and
saving the data in an excel file and linking it to that but it has a 32k
cell limit size which is too small

Thanks

Andrew