Copy pictures from access to into a word document using VBA

[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!

 

[Jean-Guy Marcil]

Bonjour,

Dans son message, < Henk de Wolde > écrivait :

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!

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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org