• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mailmerge using Java API

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

We have a customer requirement to generate MS Word (2003, 2007) reports and letters using mailmerge, programatically. The MS Word templates will be created by the users and the placeholders will be populated from Oracle database.

Is there any framework or API for doing the above?

Thanks,
Asish
 
Ranch Hand
Posts: 252
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to Java Ranch

may be Apache POI will work for you
[ July 25, 2008: Message edited by: Pratap koritala ]
 
Ramya Chowdary
Ranch Hand
Posts: 252
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
.Net better suites if you want to work with office file formats
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
POI is a library for reading and writing Office files; it has no facilities for performing a mail merge.

If you can get OpenOffice to do this, you should be able to drive it from Java code (OO has an extensive Java API, albeit one with a steep learning curve).
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Asish Mishra wrote:Hi,

We have a customer requirement to generate MS Word (2003, 2007) reports and letters using mailmerge, programatically. The MS Word templates will be created by the users and the placeholders will be populated from Oracle database.

Is there any framework or API for doing the above?

Thanks,
Asish



Hi
did you get any solution for this.
I really need similar code.
Please help.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Look at XDocReport which gives you the capability to create your report with MS Word with docx with mergefield which uses Freemarker/Velocity syntax and merge it with Java value: please read Quick Start. Its possible too to convert the generated docx report to PDF or HTML. XDocReport is full Java (no need to install MS Word).
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic