INCLUDE PICTURE as merge field

[S Vassmer]

Hi! I'm using Word 2000 & Access 2000.

I read & followed the instructions on the web page "Mail
Merge FAQ" to merge pictures from a database but I'm still
having problems.

I have a folder for the signatures (24-bit bitmaps) and
each file is named for each person (e.g., Davis, Smith,
etc.).

My db has the file name (Davis, Smith, etc.) in the field
called Signature.

My merge doc has this as the merge field:
{INCLUDEPICTURE "R:\\Team Merge letters\\Sigs\\{MERGEFIELD
Signature \* upper }"}

I do the merge, use Ctrl+A to select the entire doc, then
F9 to update the fields.

Instead of the bmp image, I'm getting an empty graphics
box.

Any ideas of what I may be doing wrong?

Thanks,
S Vassmer

 

[Graham Mayor]

See http://www.gmayor.dsl.pipex.com/mail_merge_graphics.htm

The likely omission is the file type indicator in the filename.

Insert {Mergefield Signature} into your document and ensure that the result
matches the filename of the image.

I assume that the signature images are named Davis.BMP, Davis.TIF or
Davis.JPG and that the Signature field has Davis?
You need to tell the mergefield about this e.g. (for jpg)

{IncludePicture "R:\\Team Merge letters\\Sigs\\{MERGEFIELD Signature}.jpg"}

If you have not already done so, it would be advantageous if you set Windows
Explorer to display the extensions of known file types. You can then more
readily see what you are dealing with.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[S Vassmer]

Thanks, I got the right image to the right name. My merge
field looks a little different than what's on the website
example.

I used the Insert menu & drilled down to one of the images
and used Link to File. Then I "tweaked" the field to
read: {INCLUDEPICTURE "R:\\Team Merge
letters\\Sigs\\{MERGEFIELD Signature}"}

WITHOUT the .bmp after Signature}.

I'm guessing it worked for 1 or 2 reasons: 1) on my db
table, the signature field is like Davis.bmp, and that's
where Word is learning what type of image it is. 2) By
using the Insert & Link to File, Word knows what type of
image it is and because all of my images are bmp's it's
okay.

Can you tell me if either of these make sense to you?

I'm now trying to do the macro to automatically update the
fields, but that's another story.

Thanks again,
S Vassmer

-----Original Message-----
See http://www.gmayor.dsl.pipex.com/mail_merge_graphics.htm

The likely omission is the file type indicator in the filename.

Insert {Mergefield Signature} into your document and ensure that the result
matches the filename of the image.

I assume that the signature images are named Davis.BMP, Davis.TIF or
Davis.JPG and that the Signature field has Davis?
You need to tell the mergefield about this e.g. (for jpg)

{IncludePicture "R:\\Team Merge

letters\\Sigs\\{MERGEFIELD Signature}.jpg"}

 

[Graham Mayor]

As long as the resolved field produces the correct path and the full
filename that is all that matters. In the example the field held only the
name and not the filename extension. Yours apparently has both.
You'll find information about installing macros in the last item on the Word
pages of my web site.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[S. Vassmer]

I came back to check on a thread about INCLUDE PICTURE
(posted 9/3/2003).

But when I open the 3rd & 4th posts, I get the
message "Message Unavailable".

Anyone know what this means?

-----Original Message-----
See http://www.gmayor.dsl.pipex.com/mail_merge_graphics.htm

The likely omission is the file type indicator in the filename.

Insert {Mergefield Signature} into your document and ensure that the result
matches the filename of the image.

I assume that the signature images are named Davis.BMP, Davis.TIF or
Davis.JPG and that the Signature field has Davis?
You need to tell the mergefield about this e.g. (for jpg)

{IncludePicture "R:\\Team Merge

letters\\Sigs\\{MERGEFIELD Signature}.jpg"}

 

[Peter Jamieson]

No, but the new text in the 3rd and 4th messages I see is as follows:

-------------------------------------------------------
<3rd message>

Thanks, I got the right image to the right name. My merge
field looks a little different than what's on the website
example.

I used the Insert menu & drilled down to one of the images
and used Link to File. Then I "tweaked" the field to
read: {INCLUDEPICTURE "R:\\Team Merge
letters\\Sigs\\{MERGEFIELD Signature}"}

WITHOUT the .bmp after Signature}.

I'm guessing it worked for 1 or 2 reasons: 1) on my db
table, the signature field is like Davis.bmp, and that's
where Word is learning what type of image it is. 2) By
using the Insert & Link to File, Word knows what type of
image it is and because all of my images are bmp's it's
okay.

Can you tell me if either of these make sense to you?

I'm now trying to do the macro to automatically update the
fields, but that's another story.

Thanks again,
S Vassmer
</3rd message>
-------------------------------------------------------
<4th message>
As long as the resolved field produces the correct path and the full
filename that is all that matters. In the example the field held only the
name and not the filename extension. Yours apparently has both.
You'll find information about installing macros in the last item on the Word
pages of my web site.