Home » Developer & Programmer » Forms » mail merge with Oracle forms and Word
mail merge with Oracle forms and Word [message #238314] Thu, 17 May 2007 07:00 Go to next message
vj12345
Messages: 1
Registered: April 2007
Junior Member
hi,

I'm attempting to create a mail merge between Word and an Oracle Form. The form letter will exist in Word, but the data source will be a sql query from the database. The user will interact with a form to create a query that will generate records to be automatically merged into the Word document.

I know I could create a simple file based on the query and have the user merge that, but that isn't acceptable for this project. This needs to be completely automated -- the user shouldn't have to do the mail merge in Word at all.

Any help or suggestions would be very much appreciated
Re: mail merge with Oracle forms and Word [message #238943 is a reply to message #238314] Mon, 21 May 2007 01:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The following is a Word example:
Ole2 data from database to word document
http://www.orafaq.com/forum/t/80617/0/unread/67467/#msg_233229

These are an extensive list of work in Excel, they may contain hints you can use:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/

David
Previous Topic: CAN I USE 60 DIFFERENT VIEWS IN ONE BLOCK DYNAMICALLY?
Next Topic: pls Suggest me Forms websites and books & oracle 10g forms (merged)
Goto Forum:
  


Current Time: Wed Dec 07 18:20:21 CST 2016

Total time taken to generate the page: 0.08231 seconds