Mail Merge Images from Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Tackett - 12 Feb 2006 23:34 GMT

I have aan Access database with images of people in bmp format. I want to
print name tags by mail merging to a label. I want to use the firstname, last
name and photo of each participant on the name tag.

Reply to this Message

Doug Robbins - Word MVP - 13 Feb 2006 05:22 GMT

You will need not the picture in the database, but the filename of the
picture.

See the article "Graphics on Labels" on fellow MVP Graham Mayor's website at

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

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

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

See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.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

>I have aan Access database with images of people in bmp format. I want to
> print name tags by mail merging to a label. I want to use the firstname,
> last
> name and photo of each participant on the name tag.

Reply to this Message

Richard Tackett - 14 Feb 2006 15:48 GMT

Thanks! I'm getting closer. I built the following INCLUDEPICTURE in the label
using the wizard that you get by going to INSERT/FIELD/INCLUDEPICTURE:

{INCLUDEPICTURE "C:\\Pix\\{MERGEFIELD photo}.jpg"}

The merge worked and a picture frame was included. The image was not there
though. There was the type of icon like you see on a web page when there is a
problem with the link to the image file.

My picture image is named SmithJoe.jpg and is stored in the directory
C:\Pix. There is a field in the table named photo that contains the text
SmithJoe.

Thanks for the help!

> You will need not the picture in the database, but the filename of the
> picture.
[quoted text clipped - 17 lines]
> > last
> > name and photo of each participant on the name tag.

Reply to this Message

Doug Robbins - Word MVP - 13 Feb 2006 05:23 GMT

Actually, Access has a label wizard that can probably do it all for you.

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

Reply to this Message