Merging images from an MSAccess database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Veli Izzet - 03 Nov 2005 09:50 GMT

Hi all,

I have an Access 2003 database, where one of the fields has the location
of the images of items in the database.

The images are located in the /slides subfolder in the folder where the
access database is in, so the values in field that shows the image
locations are like "/slides/Bi05K001.jpg"

How can I merge the images to word 2003? I read Cindy Meister's FAQ but
could not understand the syntax.

(Actually the ItemId's are like "Bi05K001xx". I use the second field
just to have the full location of the images. If I can create this from
the ItemId field like "/slides/&"Left(ItemId,8)&".jpg" on the fly, I may
also get rid of the image location field.)

Thanks for help.

Reply to this Message

Doug Robbins - Word MVP - 03 Nov 2005 19:58 GMT

See fellow MVP Graham Mayor's instructions for how to do it at:

http://www.gmayor.com/mail_merge_graphics.htm

Signature

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

> Hi all,
>
[quoted text clipped - 14 lines]
>
> Thanks for help.

Reply to this Message

Graham Mayor - 04 Nov 2005 07:57 GMT

If the images are in the slides sub folder of the data file folder then the
following should work

{INCLUDEPICTURE ".\\Slides\\{ItemId}.jpg"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi all,
>
[quoted text clipped - 14 lines]
>
> Thanks for help.

Reply to this Message