Hi, I have a web based app within which is a module that allows users to generate a set of letters for mailing based on names stored in a sql db. I have used CR to generate the salutation & signature sections of the letter, but hoped to leave the body text dynamic. It is hoped that a user will simply upload a .doc file and this will form the body of the letters, this .doc file will always be saved into the same place & have the same name. The main reason for using .doc is to try and maintain any formatting.

I have tried two approaches to include the doc in the report, inserting on OLE Object and setting it as LINKED, however, the report does not refresh the changed/new doc until the design view of the report is opened and the ActiveX kicks in to update the link - can this update be forced through code? Tried opening an instance of the report and using the .refresh method but it didn't work. I also tried using sub-reports, didn't work either.

Approach two was to save the document in the db in a blob field and push it into the report. However, the report treats the blob field like an image and only shows the "broken-link" icon on the report. If I export the report to either .pdf of .doc it places a different blob field image (used for company logo image - stored in separate table to the document) into the place holder for the document???

Any/All help gratefully accepted
Completely stumped