The link to the MS support doc that strongm posted looks like it's on the right track, but my Access doesn't seem to HAVE some of the controls specified. If I insert the letter into the table through VBA, it is inserted as 'Long Binary Data' and not 'Word Document' - which of course, won't display. This approach DOES work, as long as I manually cut/paste the letter into the table. DocSource property of an unbound OLE object, passing the file path, I've tried storing the letter in a seperate table along with the area and setting the control source of a bound OLE object. I don't really care how it's accomplished. I would like to somehow open a file dialog, choose the letter for EAST, a dialog for WEST etc etc and have the report come out with the appropriate letter on the first page. 100 or so, divided into 5 areas - EAST,WEST,NORTH,SOUTH,CENTRAL.Įach of the managers for those areas provides me with a short (<1 page) letter in Word, that goes on the first page of the report. Each month I run a number of reports, approx.

Vba auto increment file name changer