Mail Merge with Access as a data source
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?
|