merge a photo from access database into word

[jon]

Is it possible to merge a photo that is in an access
table database into a word document using mail merge?
When I attempt it, it merges a number only? Thank you!

Jon

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See the "Graphic from a database" item under the "Special merges" section of
fellow MVP Cindy Meister's website at:

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

 

[jon]

Thank you for the reply, unfortunately it hasn't worked. I have Office XP. When i follow the instructions for Includepicture, immediatly after I insert the field everthing disappears. Additionally, I have tried using the insertpicture option but I get an error messsage when i merge.
In the access table field i have the name of the picture and have its properties set to text, Is this correct for the merge.

Thank you

Jo

----- Doug Robbins - Word MVP - DELETE UPPERCA wrote: ----

See the "Graphic from a database" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.ht

--
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 help
Doug Robbins - Word MV

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Yes, in the database you will need as a minimum, the filename for the
picture. If that is all that you have there, you will need to supply the
path in the Mergefield and note that the path separators must be doubled \\

Did you follow Step 5 of Cindy's instructions - updating the fields in the
document after the merge?

Also, you must use Ctrl+F9 to insert each pair of field delimiters { }.
Ordinary curly brackets will not work.
--
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

 

[Frank Haschka]

I've read this thread with great interest as the end
result originally requested is precisely what I need to
achieve. However, please pardon this ridiculous question.
How do you get the 'IncludePicture' field in to the
document in the first place, to then nest the mergefield?
(as suggested in Cindy Meister's site). 'Help' suggests
just 'Insert/ Picture from file' and link to file, but
then how do I see the code and adjust it? A very new area
for me, so my apologies for the daft query!

I'm stuck with Office '97 by the way.

Cheers
FH

 

[Jon]

Thank you for your patience. I have attempeted each. This
is the path I have input.
{IncludePicture "C:\\fe\\{MERGEFIELD
Equip_Recommendation}"}

In the Access table field of Equip_Recommendation I have
my photos identified as test1.jpg and test2.jpg and so on

When I use ctrl+a and F9 it returns this error message.
Error! Bookmark not defined.

When I attempt to insert the mergefield with the
includepicture command, as soon as I hit enter to insert
the mergefield the enire line disappears (and does not
execute).

Thank you again!

 

[Jon]

I am not sure what I was doing wrong but I think I have
accomplished it. There is just one more challange, The
same photo is in each merged document. The only way to
change this is to ctrl +a and f9- however this just
duplicates the problem with the other records. Is there a
way to have the correct picture with each merged record?
If not do you have any other suggestions?

Thank you again!!!!!!!

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Jon,

What is the problem with the other records?

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

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Use Alt+F9 to toggle on and off the field codes. Or use Ctrl+F9 to insert
and empty pair of field delimiters { } then manually enter the text
INCLUDEPICTURE etc.

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

 

[Frank Haschka]

Many thanks!
It's all working now. It baffles me how the refresh works
AFTER the merge, but it works, and that's good enough for
now!

F

 

[Guest]

The same photo is merged into each record. If I update
with F9 it changes the photo for the record but it
changes it to the same photo for all records.
Thank you,

Jon

 

[Graham Mayor]

You have to select all CTRL+A then F9 to update all the images - see
http://www.gmayor.com/mail_merge_graphics.htm

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Thank you, I didn't understand that you couldn't do this
in the individual record view. However when I convert the
entire document it is placing a picture in records that
don't have one listed in the merge field. It basically
cycles through the pictures and repeats the cycle. How do
I correct this?
Thank you!!!!

 

[Graham Mayor]

I don't understand what you mean. If you insert the images as described in
the web page I posted, then if there are no images to insert it won't insert
them. You have to update the new document after you run the merge - as
explained. What cycle is there to repeat?

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Sorry for the confusion,
There are a total of 15 records, three of which have
photos. I followed the procedures as recommended. after
the merge and update all 15 records have photos attached.
record 1,4,7,10,13 all have the photo associated with
record 1. record 2,5,8,11,14 have the photo associated
with record 2, and record 3 has the remaining.

Jon