Copy pictures from access to into a word document using VBA

H

Henk de Wolde

I have setup a report that scans through an access database and dynamically
generates a formatted word document (using ADO/SQL and TypeText, etc).
However I cannot figure out how to get the pictures stored into the database
(OLE fields) into the word document. Just a reference to the function calls
or method to use is fine already!

Thanks in advance!
 
J

Jean-Guy Marcil

Bonjour,

Dans son message, < Henk de Wolde > écrivait :
In this message said:
I have setup a report that scans through an access database and dynamically
generates a formatted word document (using ADO/SQL and TypeText, etc).
However I cannot figure out how to get the pictures stored into the database
(OLE fields) into the word document. Just a reference to the function calls
or method to use is fine already!
Click to expand...

Presumably you can get the actual path from Access.
Once you do, use Word's AddPicture method to insert the picture (you have
the option of inserting it or embedding it):

expression.AddPicture(FileName, LinkToFile, SaveWithDocument, Left, Top,
Width, Height, Anchor)

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top