Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2005

Tip: Looking for answers? Try searching our database.

Mail Merge XML

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shaun - 11 May 2005 16:51 GMT
Hi,

Is it possible to do a mailmerge using an XML file? We are currently opening
the XML file with Excel and then but this is causing issues because we have
a number that is 21 digits long and Excel is only accurate up to 15 digits.
Therefore if we can mailmerge directly from the XML file we can solve the
issue :)

Thanks for your help
Peter Jamieson - 20 May 2005 12:36 GMT
Unfortunately you cannot use an XML file directly as a data source.

If your XML data source is in essence a "flat file" in XML format, and has
fewer than 63 or so columns, then you could try using an XSL transform to
turn it into an HTML or even Word data source that you might be able to use.
But unless you have someone around who can do all that stuff for you, it is
not a particularly straightforward process, and although I have done most of
the necessary steps, I have never put them together in a way that makes it
reasonably easy for an end user. However, for example, if you can import
your .xml into (say) Access 2003 and export it again as .xml, Access will
generate the .xml, and a .xsd schema, and a .xsl transform that can be used
as the basis for further work. After that, you /might/ be able to use the
.xsl transform to transform your original .xml file. For example, if you
have Word 2003, you can open the .xml, open and apply the transform and save
the resulting document as a .doc that you could use as a merge data source.

Peter Jamieson

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks for your help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.