Mail Merge Images from Access DB

[Richard Tackett]

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.

 

[Doug Robbins - Word MVP]

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


--
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

 

[Doug Robbins - Word MVP]

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

--
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

 

[Richard Tackett]

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!