Export picture attachment to Word Document

[Hdata]

I am trying to export an attachment item (Picture .jpg) to a word document. I have been exporting text to a word document successfully with below syntax "

With rst
strLandSalesID = Nz(.Fields("LandSalesID"))
strPhotograph = Nz(.Fields("Attachments"))

However, attachment do not work. Any suggestions / help.

Thanks

 

[Geotch]

Can you put the picture in a report, then export the report to a word file?

 

[Hdata]

No, I cannot switch to a report, I am working with an access form, along with other text. The text data exports well, not the attachment.

 

[Geotch]

Here's an example of what I was talking about.

You'll need a folder called c:\temp on your computer. It should output the text and picture from a form into a PDF file and then open that PDF file. I know you want Word and I played around with it for a little bit, but the picture won't show up in a .rtf file. I also noticed it only like .bmp picture files.

Maybe someone can help us do the same thing using Word?