Write data form Siebel application to word template file. Data is coming from various BCs in SIebel. IS this solution achievable using Siebl VB code. if yes can you provide some sample code?
Before this I had never heard of Siebel, but it seems that Siebel is either VBA (licensed from Microsoft) or so close to VBA that it doesn't matter. That means that what you want to do is almos certainly possible.
However, it is not clear what it is that you want to do. The word template is normally set up without programming. You are more likely to want to write to a Word document, rather than the template, programatically.
In the same way Mail Merge normally requires no programming. You need suitable ODBC drivers. To set it up, start the Mail Merge wizard, found under the Tools menu.
Siebel has modules which will automatically do mail merge into word template files, an example if the Proposals Module which allows quote and sales contact information to be merged.
Read up on Literature and Correspondence on Book Shelf or let me know if you need more
