Insert image into word from access

[Duncan]

I need to insert an image (jpg/bitmap) from an access application (adp), the
image is stored in an image datatype in sql server. the image (a signature)
needs to be inserted when the document is created from a word template
within the application. I'm having trouble getting the image back from the
database into a word document, does the word document need place holders
where the image should be if so how do I find these place holders.

 

[Michael Cheng [MSFT]]

Hi Duncan,

Thanks for your posting!

From your descriptions, I understood you would like to insert the image
from SQL Server into word documents. If I have misunderstood your concern,
please feel free to point it out.

Based on my knowledge, we will have to accomplish this with two steps
- Save the image to file first
The picture is stored as an OLE object, you should save these images to
files. Use Sendkeys functions.

Please download PictureBoxA2K.zip from MVP Stephen Lebans's site for more
information

http://www.lebans.com/imageclass.htm

- Call AddPicture method to load the image into word

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.