+ Reply to Thread
Results 1 to 3 of 3

Mail Merge Picture Error

  1. #1
    Registered User
    Join Date
    08-06-2016
    Location
    Atlanta, USA
    MS-Off Ver
    2010
    Posts
    3

    Mail Merge Picture Error

    Mail Merge Picture Error

    I am attempting to create a directory using mail merge in order to achieve the following outcome:
    img-1.png

    The following is the setup for my directory mail merge:
    img-2.png

    Upon completing mail merge, saving and re-opening the file, I discover the following error:
    “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.”
    img-3.png

    I located the following assistance after searching for a resolution: (link to source here)
    http://www.excelforum.com/word-forma...s-problem.html
    img-4.png

    I substituted my original picture code above with the following code suggested from source as such:
    img-5.png

    The images remain after saving and re-opening file, no errors with missing image link, but the format I desire regarding image size does not remain. I would like for the image to hold its size like in the 1st image above.

    Can someone advise here, thanks.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge Picture Error

    To control the image size, you can insert the mergefield into a single-cell table to which you apply a fixed row height and column width:
    • For the rows, set the exact row height under Table Tools>Layout>Properties>Row>Specify Height>Exactly.
    • For the columns, set the preferred column width under Table Tools>Layout>Properties>Columns and uncheck the 'automatically resize to fit contents' option under Table Tools>Layout>Properties>Table>Options.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    08-06-2016
    Location
    Atlanta, USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Mail Merge Picture Error

    Thanks macropod, the above suggestion works for me. I appreciate all the great advice you give here on the forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. mail merge picture not responding
    By roofi in forum Word Formatting & General
    Replies: 2
    Last Post: 08-16-2013, 05:04 AM
  3. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  4. Mail Merge to make picture badges for employees (2003)
    By Webtekr in forum Word Formatting & General
    Replies: 0
    Last Post: 03-02-2009, 04:51 AM
  5. Embed picture in excel mail merge into word?
    By Donna in forum Excel General
    Replies: 1
    Last Post: 03-29-2005, 06:06 PM
  6. lock a picture to a cell so i can mail merge
    By lock picture to cell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  7. mail merge error
    By Antz in forum Excel General
    Replies: 1
    Last Post: 01-11-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1