merging a picture from a database

[Bob]

I'm creating a mail merge document using Access.
I have a picture field (OLE object)that I want to merge
using a BMP file. When I merge the documents all the
fields come through except the picture. Instead, text
appears that says "Long binary or text value."
Does anyone know how I can get the picture to merge
properly?
Any help would be appreciated.
Thanks.

 

[Doug Robbins - Word MVP]

Hi Bob,

You cannot do that. You will need to have the Path\\filename of the
pictures in a field in the table and then insert that mergefield inside an
{ INCLUDEPICTURE } field in a the mailmerge main document.

See the following page of fellow MVP Graham Mayor's website
http://www.gmayor.dsl.pipex.com/mail_merge_graphics.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Bob]

Doug,
Thanks for the help.
I'm still having a bit of trouble getting this to work
though. I visited the site you suggested and I think that
I basically understand the theory, but I still can't get
this working.
I added a field to my Access database called PhotoLabel.
In that field I have placed the name of the file for each
picture, excluding the BMP extension.
In my WORD document I put in the following text:
{INCLUDEPICTURE "C:\\COGOINFO\EZINE\TESTDB\IMAGES\\{MERGEFI
ELD PhotoLabel}.bmp"}
I've tried to test this a few different ways, but there
are so many variables I'm unsure of, it's tough to narrow
it down. Some of those include:
Whether or not the quotations marks are supposed to be
included?
Should each of the forward slashes in the pathname be
doubled or only the ones at the beginning and end?
For the Access field that is merged (PhotoLabel), should
that field (in Access) be a text field or some other type.
Anyway, when I attempt the merge, no pictures come through
and when I go back to the merge document, the formula has
disappeared.
If you would prefer to answer this from your paid
consulting site, I'll certainly understand. Just tell me
how I go about that.
Thanks in advance.
Bob

 

[Graham Mayor]

You need double slashes
{INCLUDEPICTURE "C:\\COGOINFO\\EZINE\\TESTDB\\IMAGES\\{MERGEFI
ELD PhotoLabel}.bmp"}
You also need to merge to a new document, select the document CTRL+A, then
update F9 to show the results.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>