View Single Post
  #2  
Old July 10th, 2009, 11:15 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Mail Merge with Access as a data source

In you mail merge main document, you need to place quotes around the
mergefield inside the IncludePicture field

{ INCLUDEPICTURE "{ MERGEFIELD [FieldName] }" }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Christine" wrote in message
...
I have a mail merge set up between an Access database and several Word
documents. In my Access database I have a field that contains the path to
a
bmp, e.g C:\\data\\thePicture.bmp

When the merge runs, the result looks like this:

{INCLUDEPICTURE C:\\data\\thePicture.bmp \* MERGEFORMAT}

If I preview the document, the picture is not there.

I have to select the INCLUDEPICTURE statement, right click, select Edit
Field, click OK, and Word adds quotes around the picture name:

{INCLUDEPICTURE "C:\\data\\thePicture.bmp" \* MERGEFORMAT}

Then if I preview the document, I see the picture.

I've tried adding the quotes into the Access field, but that doesn't solve
the problem.

How should that path be stored in the Access field?