Prev: pdf file won't print graph in report header
Next: Conditional formatting to be visible or invisible
From: clzcyclone on 11 Nov 2009 12:29
I'm using Access 2007 with the new attachment field type.

I have a table with an attachment field that contains a .JPG image file.

I would like to do a Word merge and insert the attached image for each record
into the output document.

I have seen instructions to use the IncludePicture merge command to reference
a file based on its file path, but this does not seem to apply to files that
are actually attached in the database in Access 2007.

I'm hoping for a simple way to do this based on Access fields.

The only workaround I've imagined is writing a script to iterate through the
table and save all attached files to a single folder, after renaming the
files to a standard name based on the record ID (i.e. "1234_image.jpg"). Then
I would use the IncludePicture command to reference the files and merge them.

Any ideas out there? With the new attachment field type, you think that
Microsoft would have implemented a method to use the attached files in merges.


 | 
Pages: 1
Prev: pdf file won't print graph in report header
Next: Conditional formatting to be visible or invisible