Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Images from Access DB
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Images from Access DB
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_lab...th_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/cindy...r/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 "Richard Tackett" Richard wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Images from Access DB
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" Richard wrote in message ... 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Images from Access DB
Thanks! I'm getting closer. I built the following INCLUDEPICTURE in the label
using the wizard that you get by going to INSERT/FIELD/INCLUDEPICTU {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! "Doug Robbins - Word MVP" wrote: 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_lab...th_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/cindy...r/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 "Richard Tackett" Richard wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word opens access in mail merge. Access is already opened.=twice | Mailmerge | |||
Mail merge fails with images and section breaks | Mailmerge | |||
Cannot edit Access records from Word mail merge toolbar button | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
Word mail merge with Access | Mailmerge |