Word Mail Merge with IMAGE

Solved
Mariehdb -  
 pika -
Hello,

I am desperately trying, in WORD 2003 or 2007, to create a mail merge where I insert an image, the path of which is located in the Excel file containing all the information.

I have followed the procedures found on the web (for example here: http://faqword.free.fr/articles.php?lng=fr&pg=976), including merging into a new document at the end and updating with CTRL+A and F9.
A square exactly the size of my image appears, with a small red cross in the top left corner, and the image is never visible.

I don’t know where to look anymore. Is it a restriction in Word's display options? The image doesn't appear when printed either.

Thank you in advance.
Configuration: Windows XP Firefox 2.0.0.15

15 réponses

m@rina Posted messages 27191 Registration date   Status Modérateur Last intervention   11 542
 
Hello

The problem has nothing to do with the image sizes. In fact, it's best to add the switch \d so that the images are linked and not inserted, if the goal is to print and not to keep the file.

Whether you put the path before the field or in the database makes no difference.
Are you sure that the image is indeed at the root of C:?

Try the following:
- Insert, Picture, from file, choose your image, and select Insert as link
- Switch to code view (Alt+F9) and copy the name with the full path of the image without the quotes
- Paste it all into your Excel cell

- Restart your merge by removing the c:\\ :
{ INCLUDEPICTURE "{ MERGEFIELD foto }" d }
making sure that your field is indeed called "foto"

Restart the merge (and of course not just the preview).

m@rina
8
iris89
 
Hello Marina,

Your mail merge procedure with images works very well.

I have a complication that arises afterward: I want the merged images to use the entire space of my table cell.
I need each image to actually be a full page (well, almost since I have a few lines of text above).
With a table cell or by another means, do you have a solution to propose?

Thanks in advance.

Iris89
0
marcb03
 
Hello again,

I'm sorry, but after some digging, I managed to insert an image from the mail merge field using the code: {INCLUDEPICTURE {MERGEFIELD Photo} d}.
The problem is that it doesn't take the value of the Photo field specific to each record, but instead keeps the first photo I inserted as a link when viewing the code with Alt F9.

???

Thank you for your responses.
3