Consulting

Results 1 to 2 of 2

Thread: Email Images in Mail Merge

  1. #1
    VBAX Newbie
    Joined
    Mar 2023
    Posts
    1
    Location

    Email Images in Mail Merge

    Hi experts
    I need to create some e-mails from Word (via Outlook) that contains different pictures for different recipients. All the date is imported from an excel file (name, email, picture path).
    When using Merge function I get the emails, but the pictures are the same in all the emails (pic1.png and not pic2.png and so on). The rest of the fields are fine.
    For the "Finish and Merge" with "Edit individual documents" I get the documents and pictures (also just one picture for all) and with Ctrl-A and F9 I can see the correctly generated files (all the fields and the pictures are what they are supposed to be).
    What should I do to have the right pictures in emails? It's like they don't get refreshed while generating.

    I use this codes (picture cell contains the full path, eg: D:\\test\\pic1.png), both are working the same way:

    {INCLUDEPICTURE "{MERGEFIELD picture}" \*MERGEFORMAT\d}

    {INCLUDEPICTURE "{MERGEFIELD picture}"\D}

  2. #2
    You need a particular syntax when mailmerging images or the images don't update. See https://www.gmayor.com/mail_merge_graphics.htm and https://www.gmayor.com/mail_merge_graphics_addin.htm
    You may also find https://www.gmayor.com/email_merge_addin.html useful
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •