Merging Images from Access to Word

  • Thread starter Thread starter jedost77
  • Start date Start date
J

jedost77

Guest
I am building a database for my job. I am trying to find a way that I can mail merge an Image that store in Access to a Word document. I tried doing it by creating a field in Access for the picture and its field type was set to OLE Object and I placed the merge field in its appropriate area in Word. When I go to merge it, its comes up with a message that says "Long Integer or Binary Number". If anyone has an idea as to how I can make this happen....please let me know, your help would be greatly appreciated.

Thank you
 
I think the only way you can do this is through Office Automation techniques. You open Word as an application object, then have Word open the document. You have to find the place to put it, then use the app.object controls/methods to insert the image where you wanted it to do. Since I have not done this exact step before, I'm not sure I can suggest anything except to read up on Applications Objects in Access and on VBA interfaces to Programming Features in Word.
 

Users who are viewing this thread

Back
Top Bottom