Only get a red x after merging pictures

Anonymous
2010-04-14T02:24:00+00:00

My data source is an xlsx file and one field (PictureLocation) has the full path name of each jpg file I want to merge into a document.  I use this merge function:  {INCLUDEPICTURE "MERGEFIELD PictureLocation}"} which works fine except I only get a box with a small red x in upper left-hand corner where the picture should be.  I have tried F9, but to no avail.  What am I doing wrong or what have I set incorrectly?  I use VISTA and OFFICE 2007. dottybee

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
2010-04-14T05:38:23+00:00

What is in the PictureLocation field?

The filepath separators need to be duplicated \ or you need to use / as a separator.

Was this answer helpful?

0 comments

55 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2010-07-02T23:45:57+00:00

    To Doug -

    that answer would be just brian, melinda, jim, beverly, etc, no extension

    How's that?

    To Susan,

    I'll do as you suggest.  I'll work on it some more over the weekend and let you know the results.  Good, bad or indifferent. Thanks.

    Was this answer helpful?

    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2010-07-02T20:54:59+00:00

    Your answer to the third question (What is the name of the field in your data source that is intended to contain the information relating the pictures (e.g. the file name of the picture, with or without the path.)?) is not correct.

    The field will only have one name and no extension.

    The answer that you have give to the third question sounds more like it might be the answer to the fourth question (What information do you have in that field in your data source?  (Give us typical, but factual examples.)

    What is the answer to the third question?

    Was this answer helpful?

    0 comments
  3. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-07-02T19:54:07+00:00

    Press Ctrl+F9 and type INCLUDEPICTURE "C:\Users\MIMI\Pictures\.jpg" between the braces. You don't need (and probably don't want) the \* MERGEFORMATINET switch.

    Now place the insertion point before ".jpg," click the Insert Merge Fieldbutton on the Mailings tab of the Ribbon, and select the "pictures" field.

    Was this answer helpful?

    0 comments
  4. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-07-02T19:47:04+00:00

    I don't know what you're referring to, but I think all the answers have been provided numerous times already.

    Was this answer helpful?

    0 comments