Image merge to word from access.

[Siggenis]

Hey guys,

I just joined this forum and I have to say, very good stuff in here!!.

Ok, so this is my question:

I have an intermediate level experience in access.
I am a private investigator and have created a beautiful access database to manage my case intakes, case progress, investigators, clients 8nvoices, expenses and a whole much more for my business.

I have integrated word merge in my database to generate final reports etc. The problem that I have and cannot for the life of me figure it out is how can i merge an image that is attached to a record to word?

Basically i create a new case and input all pertinate information for that specific case and in that case I add an image of the subject, google maps for the residence and other images such as facebook screenshots etc.. and what i want to do is when I merge the case with word to also have a page in word to include this images.

Is it doable? And if so, how?

Thanks!!!

 

[Isskint]

Hi Siggenis

Word merge? I take it you mean Mail Merge in Word? If so it is doable if the images are links to the image and not the image itself (although there are ways to do this also but very different). Have a look at this article for guidance. https://support.microsoft.com/en-us/kb/909132

Also have a look at this article https://support.microsoft.com/en-us/kb/103257 for advice around saving embedded images to disk

 

[arnelgp]

can you describe the structure of your ms access table you are using as mail merge. which field holds the image? is it attachment type field?

 

[Siggenis]

I basically have a cases table which is the control source for the Case Details form.
In the cases table i have all the informatuon to create a new case which also included the attachments.
Now, when I go to Subject information in Case Details form i can type all pertinate information for the subject and also attach a picture of him/her which i can see in the case details. I also have another tab in the case details form named Social Findings which i attach a screenshot of social pages which again i can see in case details form and so one.
Basically whatever image i attach in the case details form I can see it but when i try to mail merge and in word i put the source from the table it does not show the image and i have to add it manually ehich as you can guess time consuming.

 

[jdraw]

SIGGENIS,

Can you show us your tables and relationships (zip a jpg)?

 

[Uncle Gizmo]

Are the images in a folder and linked to via a path name?

 

[Uncle Gizmo]

I deleted your double post.

Don't do it again!

 

[Siggenis]

To Uncle Gizmo.

Sorry about double post.

Yes, the image files are in a folder and I just attach to Case Details Forms for the specific record.

I will upload image of tables and relationships once I get to office.

 

[Uncle Gizmo]

I have had a mess around with some old code provided by Helen Feddema. I couldn't get it to work consistently, I kept losing the dot file. Looking into it briefly, The modern word program uses template files with a *.dotm extension and that's where I was having the trouble.

Helens code copied over the data just fine using the sample database provided, however when I changed the salutation text to a UNC "C:\\Manual\\Art\\Art 22.gif" linked to an image file, and also changed the field in the word document to one that would accept an image UNC I ran into problems.

However I suspect I'm on the right track, although I also suspect there may be an updated way of doing this, as this code and method is quite old. I can't carry on researching it at this time as I've other things to do.

Here are all the links that I found interesting, and my notes as well. Hopefully you will find it a good start, or at least it will prompt somebody to improve on,or suggest an alternative.

Web Help:-
http://www.wordbanter.com/showthread.php?t=130604
Field codes: IncludePicture field


Add individual images to Mail Merge (Excel)
https://www.youtube.com/watch?v=R80l8rEa1lQ

Helens Site
http://www.helenfeddema.com/Code Samples.htm

See This;-
Access >>> Word
Item:-
24, VBA Merging to Word Four Ways 6/9/2002
Download This:-
http://www.helenfeddema.com/Files/code24.zip

Move Helen's dots to here:-
c:\users\tony\appdata\roaming\microsoft\templates\Contact Letter DP.dot template not found; can't create letter

docx created saves to Here:-
Saves to:-
C:\Users\Tony\Documents

Odds And Sods
"C:\\Manual\\Art\\Art 22.gif"