Mail merge with PIctures

Question

Mail merge with PIctures

Ashleigh Milburn 0

I have looked through some questions and answers on this forum and have found what i am looking for however i need it tweaking.

I am looking to include a picture or multiple pictures into a mail merge email. IF a column says "Yes".

I so far have this..... User's image

Please can someone help me amend this for only lines that need images.

Thanks

2 answers

Your answer

Answer 1

Ashleigh Milburn 0

User's image

Hi Thanks for your response, i have added the above code and added the merge fields, however the images are not showing up in the preview?

Hope you can help again

Thanks,

Kai-L 11,255 Reputation points Microsoft External Staff Moderator

2026-02-25T15:42:47.2366667+00:00
Dear @Ashleigh Milburn,

Thank you for your update. If you’re in Preview Results mode and don’t see the image, try the following steps:

Press Alt + F9 to display the code, and then press it again to return to the result view.

Ensure the image path is correct:

If your images are stored on your computer, use double backslashes in the path (e.g., C:\Users\Pictures\Image1.jpg).

Make sure the ImageURL column in Excel includes the file extension (e.g., .jpg, .png). If not, modify the merge field code like this: { INCLUDEPICTURE "{ MERGEFIELD ImageURL }.jpg" }

Sometimes the preview may not display images properly, even with the correct settings. In this case, test the merge by creating the final document:

Go to Mailings > Finish & Merge > Edit Individual Documents.

Choose All and click OK.

Update the fields: In the new document that opens (usually called "Letters 1"), you may still see no image or an incorrect image.

Press Ctrl + A to select all, and then press F9 to update the fields.

Thank you for your patience and understanding. I look forward to hearing from you with an update.
Kai-L 11,255 Reputation points Microsoft External Staff Moderator

2026-02-26T20:38:55.6566667+00:00

Dear @Ashleigh Milburn,

It has been a while and I am writing to see how things are going with this issue. If there’s anything else I can assist you with or if you need further clarification, please don’t hesitate to let me know, I’m here to help. Looking forward to hearing from you. Wishing you a great day ahead!

Answer 2

Dear @Ashleigh Milburn,

Thank you for reaching out to Microsoft Q&A forum.

I understand that you would like to include one or multiple pictures in a mail merge. Based on your screenshot, the first command is spelled INCLUDEPICTIRE. This spelling error will prevent Word from recognizing the field. It must be spelled INCLUDEPICTURE in both instances.

To display images only when a specific column (for example, "ShowImage") contains Yes, you can use the following nested field structure:

{ IF { MERGEFIELD ShowImage } = "Yes" "{ INCLUDEPICTURE "{ IF TRUE { MERGEFIELD ImageURL } }" \d }" "" }

Breakdown of this logic:

The Outer IF: Checks if the ShowImage column equals "Yes".

If yes, it runs the INCLUDEPICTURE command.

The IF TRUE: This is to force Word to refresh the image for every record, rather than showing the same first image for everyone.

The \d switch: This tells Word not to store the image data in the file, which is essential for dynamic updates.

Additional notes:

Remember to press Alt + F9 to toggle between the "Result" view and the "Code" view so you can edit these manually.
You cannot just type the curly braces { }. You must create them by pressing Ctrl + F9 for each set of brackets.
Ensure the data in your MERGEFIELD Image column contains the full path (e.g., C:\Images\Photo1.jpg or a full web URL). Note that local paths in Word often require double backslashes.
When merging to email, images may be blocked by the recipient’s mail client. For better reliability, consider using web-hosted image URLs.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this. Thank you for your patience and understanding. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you. I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Mail merge with PIctures

2 answers

Your answer