access mailmerge to word including image

iankerry

Registered User.
Local time
Today, 20:01
Joined
Aug 10, 2005
Messages
190
Hi All

Thanks to the forum I have managed to do 95% of what i need to do.

I have a database of film events, for which i have to do posters.

With the click of a button on a form, access opens word and puts all the fields in, including a field called [photo], which is the name of the image stored outside of the database.

Is there a way of getting that image into the word Document with all the other fields? Or have I just wasted an afternoon....

Your thoughts appreciated.

Ian
 
Was looking into that a while back. Decided not to use Word.
http://windowssecrets.com/forums/showthread.php/146926-Inserting-an-image-via-Mail-Merge

Here is what the person who uses it all the time said:
I have mastered it now but the merge code is notoriously unstable. Even after you get it working if you save your template under a different name the code comes undone. If you merge to a different spreadsheet it comes undone. If you try to use the position tool on a graphic it comes undone. If you open a template on a different computer it comes undone. Having said that and after playing with it for several months I discovered all the quirks and rules to using it and got it working smoothly.

Granted, they are using Excel, but the concept will be the same.
It appears that Microsoft couldn't make it easy anymore.
 
You probably have given up hope on doing this since this is an old post but I was scouring the internet for a way to do this very same thing several months back and I did eventually find a way. All credit is given to Amir Parmar's channel on YouTube. That's where I got most of the help I needed to do this. If you or anyone else is still trying to find a solution for this I recommend checking out his channel. I would also be willing to help because even after watching those I ran into trouble. Just from opening up one of my documents that I was doing this with I can give you this...

It involves inserting a field in your mailmerge document:
{ INCLUDEPICTURE "{ MERGEFIELD Photo }" \* MERGEFORMAT\d }

There are several things this process is picky about:
It is VERY picky about formatting and my Word occasionally crashed while trying to alter this field. However, I haven't had issues like that after getting it all set up.
You have to enter the {}s by pressing ctrl-F9, they aren't recognized otherwise. Also this did not work in .docx files so you'd have to set up your template as .doc document.
Your Photo field would most likely have to be altered because the INCLUDEPICTURE needs it to be in the format C://filepath//filename
 
Last edited:

Users who are viewing this thread

Back
Top Bottom