Mail Merge Questions

[Nice Chap]

I have been trying to use Mail merge to produce word documents dynamically.
The problem I am facing is that the data source that Word expects is flat.
i.e it can contain only one table which is quite limiting. I am looking at
producing documents that are more complex than simple letters. They contain
for example a client details and all of his recent orders, historical
orders, his payment details and so on.

Example:

Client Name
Address

Current Orders
--------------
1. ---
2. ---
3. ---

Previous Orders
------------------
1. ---
2. ---

Payments Received
----------------
1. ---
2. ---
3. ---
4. ---

and so on..

1. Can I achieve such a complex document using Mail Merge at all ?
2. Is it possible to use XML files as datasources?

Thanks for reading this post.

Any help would be greatly appreciated.

 

[Stuart]

I do a lot of stuff like that with separate documents that are combined
together with VB code.

 

[Nice Chap]

Thanks Stuart for your reply, are there any examples of these? I have
searched the web but could not find any. I got an example from MS but that
produced only a maximum of 4 rows in a child table. Any sample would be much
appreciated.