Consulting

Results 1 to 2 of 2

Thread: Mail merge help

  1. #1
    VBAX Newbie
    Joined
    Oct 2019
    Posts
    1
    Location

    Mail merge help

    Hi all,

    We’ve recently upgraded to the latest version of Microsoft Office and Dynamics 365 (CRM) and are having some teething problems. In Mail Merge, everything works fine apart from the following bit of code:

    { INCLUDEPICTURE "C:\\[path not shown for security reasons]\\Performance\\Yellow Boxes\\{MERGEFIELD Performance_Reference \* MERGEFORMAT}.emf" \d \* MERGEFORMAT }

    It pulls through a specific image file from the C:\\[path not shown for security reasons]\\Performance\\Yellow Boxes folder determined by the ‘Performance Reference’ field. When I complete the mail merge and click on ‘edit individual letters’, it pulls through a white box with the message "The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file and location."

    To fix it, I press Alt-F9 to toggle to the code view, right click the code, then press edit field to bring up the ‘field’ box. I then click ok (without changing anything) then when I press Alt-F9 again in the document the correct image appears. This is a pain because I have to do it individually on each letter which is a lot of clicks when we are doing mail merges for hundreds of clients at a time. It seems strange to me that clicking edit then ok without changing anything fixes the problem.

    The file is a .emf. I'm not sure if that this is part of the problem.

    Thanks for the help in advance!

    Best,
    Justin

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    3,891
    Location
    Cross-posted at: https://www.msofficeforums.com/mail-...ail-merge.html
    Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq...._new_faq_item3
    Cheers
    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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