I have a contract document (six pages) which requires specific clauses to be customised with fields from my database.
The contract exists as a Word Document which is manually modified with the required data at the moment. My aim to have a button on one of my forms which generates the contract (report) with the fields embedded at the right points throughout the document. i.e. It picks up Name, address etc etc from the customer file and populates the contact (report) as required.
I'm struggling to do this using a report.
I've tried starting with a blank report and tried various ways of cutting and pasting the text from the Word document into labels and unbound fields - none of which work and I can't seem to master the OLE concept. I can get the Document into the report and I am given the opportunity to edit it, but I can't master the pagination.
Can anyway suggest the best way or the right way to go about achieving this?
Jimbo