M. Merge Pics into Word 97 / from Excel 97 not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 16 Dec 2003 13:52 GMT

>-----Original Message-----
>> I have followed then instructions as on your web site -
>> still does not work and the error is "file name not
>> specified" Please note that I am using excel as the

data

>> source. The photo field in the spreadsheet points to

the

>> file.jpg in the same folder as the spreadsheet.
>> By place holder I mean a box does appear which should

>> the picture, but it does not appear!!
>>
>Check in Tools/Options/View whether "Picture placeholder"
>has been activated. If it has, turn it off and you should
>be OK?
>
>Cindy Meister
>INTER-Solutions, Switzerland
>http://homepage.swissonline.ch/cindymeister (last update
>Sep 30 2003)
>http://www.mvps.org/word
>
>This reply is posted in the Newsgroup; please post any
>follow question or reply in the newsgroup and not by e-

mail

>:-)
>
>.
>Hi - Thanks but this was turned off (not ticked) - I have

shown below the formula entered into the word document and
the result - hope this helps ?? I am using Excel 97 as the
database:

Formual:
{INCLUDEPICTURE "C:\\Documents and
settings\\RKING\\Desktop\\test\\{MERGEFIELD Photo}"}

Results in:
Error! Filename not specified.
The spreadsheet, the word document and the images are all
store in the same folder "test"

My spreadsheet looks like :

Name     Description Price Photo
Bell Alarm Clock    25    Chubb.jpg
candle Holder    Holds candles    35    tank blaze.tif
Cash Box    with lid     45 C:\\Documents
and Settings\\RKING\\Desktop\\test\\Chubb.jpg

As you can see, I have tried it with just a file name and
also with a path - still does work for me

Hellllllllppppppppppppp!!
.

Reply to this Message

Cindy M -WordMVP- - 18 Dec 2003 17:25 GMT

Hi Ray,

It would be very helpful if you use REPLY to the existing
discussion ("thread"), so that we can keep track of the
entire conversation.

I want to take a few steps backwards, to try to find out at
exactly what point the problem is occurring.

Position the cursor at the end of your mail merge document
(or a copy!) and use Insert/Picture/From File to choose one
of these jpg you want to use in the merge. Activate the
option to link it in.

Do you see the picture?

If you press Alt+F9, do you see the IncludePicture field
code? (If not, remove the "float over text" formatting, then
try again.) Compare this IncludePicture field with the one
you tried to create. Do you see any substantial differences?

Now, delete the merge field from that IncludePicture field
and type in the file name, instead. F9, Alt+F9: do you see
the picture?

If yes, delete the file name and use the Insert Mergefield
button to re-insert the merge field. F9, Alt+F9: do you see a
picture, now?

> >> I have followed then instructions as on your web site -
> >> still does not work and the error is "file name not
[quoted text clipped - 47 lines]
> As you can see, I have tried it with just a file name and
> also with a path - still does work for me

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message