[RBergmeyer]

Peter,

I was hoping the the 2007 word object had some magic built into it to allow
handle xml data type with mailmerges. Since this isn't the case, I think I
am going to try using my query to format the XML into a normal looking
dataset that Word can handle. If I run into problems, I may try option B
that you suggested.

Thanks for your help and suggestions!

Rob Bergmeyer



"Peter Jamieson" wrote:

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