Word Automation And Pictures

[Joe]

We are using Microsoft Access/Word 2007. I have a folder containing
some graphics in .bmp format that I want to insert into a Microsoft
Word document using automation. I am using Access because there is
also data that needs to be inserted into the Word document. I have
tried the following command below but it does not work

oApp.ActiveDocument.Bookmarks("CUM_RETURNS").Range.InsertFile
sClientGraphicsPath & "\Cumulative Returns.bmp", , True

But this seems more suited towards inserting text files, rather than
pictures.

How do I insert pictures into my Word document using Word Automation?

 

[a a r o n . k e m p f]

If you kept your data in a database, you could use SQL Server
Reporting Services in order to generate these word docs.

SSRS does a fantastic job of exporting reports to word.. It's 100
times better than what Access tries to do