Out of the box, Word doesn't really "understand" XML as a "data format",
at least not when you are merging. If I wanted to do this I would
probably either
a. not use merge - e.g. use one of the .NET languages+VSTO if
necessary and probably use content controls and the XML data store to do
the work or
b. (more likely given my current state of knowledge) use VBA, Word's
MailMerge event, and MSXML or some such to extract the stuff I needed
from the XML format column, insert it into Document variables, and use {
DOCVARIABLE } fields to insert those values into the output.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
RBergmeyer wrote:
Hello,
Is it possible to do a mail merge using a sql query that just returns a xml
data type column and use the xpaths to populate the merge variables?
Thanks,
Rob Bergmeyer