Access to Word mail merge

You need to hit Alt f9 TO CHANGE TO CODE VIEW of the document, and now you can code in what the relative path actually is, using the path to your attachment (record entry). I will try to work on a proof of concept and post back after I cook dinner!

I googled it, take a look here.>https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_other-mso_archive/mail-merge-with-variable-pictures-using-word-2013/32c9b910-06b8-4b9e-80eb-ccd39c22afa4

I may still work on it after din din!

Ok, did it while the rice was cooking!

See below:

The code is actually:

{ INCLUDEPICTURE { IF TRUE "c:\users\user\desktop\{MERGEFIELD Field3 }"} \d}

So make the path static, and the image is a field. If you have different storage locations, store them as the PATH, and reference them as another MERGFIELD behind the IF TRUE statement!

Have fun, I hope this works for you, as it did me!




Here is the two pages just to show it does work as one PDF:



Have FUN!

A data source is a data source. It doesn't matter. I tested it today, and the image does not come through unless you have the path to where to image is stored. I attempted the test with the Path removed, and attempted to use only the image that was a MERGEFIELD, but it did not display until I placed the path to the image. Once again, a data source is a data source, the procedure is the same regardless if it were a CSV file, or an access DB! You need the path to the file, it does not link the image stored! I hope you appreciate this and please let me know if you can prove it any different!

Oh and by the way, I used a CSV file, not excel. I just pointed my CSV file to a picture of an Excel screenshot from another answer! So, I didn't use excel neither. I used Access for the test today at work, and same result as if it were a CSV file, no image unless the path was complete to the file! This is how I know that it links to the file location, and not to the DB image.

Have FUN!