Attachments in queries

[atrium]

I create a query in access 2010 to merge into a word template.

It all works fine but I can't seem to get the contents (a graphics image - signature) into the query file.

Not sure what to reference for the attachment field when I'm creating the query.

Any help would be appreciated

 

[spikepl]

Use google. I did. http://homepage.swissonline.ch/cindymeister/MergFram.htm

Merge in a picture from a database

Word cannot merge a graphic or OLE-object directly from a database because it does not understand the type of data the database sends across (long binary). Therefore, you have to workaround this obstacle.

Save the graphics files in a folder (directory) on a drive
Place the file name (or path information) in a field in the database
Reference the graphic file information by nesting the merge field in an IncludePicture field.
Example: { IncludePicture "C:\\Data\\Pics\\{ Mergefield Signature \* upper }" }
You must now merge to a new document.
Update the field display so that each record shows the correct picture. (You can press Ctrl+A to select the entire document, then F9 to update the fields.)
Note the double backslashes in the example, as well as the double-quotes. Both are necessary if the field is to work correctly.

 

[atrium]

Thanks Spikepl, I will have a go at it.

Very much appreciated

Atrium