mail merge with pictures

[robw]

Hi

I'm trying to create a mail merge that will include a different picture for
each addressee.
The data source is an Excel xls that includes a column called XmasPic. This
entries in this column are integers between 1 and 10. I have a number of wmf
files in my c:\ folder called 1.wmf, 2.wmf ......10.wmf

In the mail merge document I have setup includes the following statement
(when field codes are displayed) :-


{ INCLUDEPICTURE "c:\\{ MERGEFIELD "XmasPic" }.wmf" \* MERGEFORMAT }


which I had hoped would pick up the appropriate picture for each addressee.
The remainder of the document (ie. the text bits) merge correctly but the
statement above doesn't seem to work....I get no picture at all.

Anybody have any ideas how to get this to work?

Thanks
Rob

 

[Graham Mayor]

Merge to a new document, select all (CTRL+A) then F9 to update.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[DBodell]

Graham and Rob, I have been having problems getting this very function to
work in Word/2000 after having it work beautifully for years in Word/97. If
there is anything you can tell me about why doing the ctrl+A and then F9
doesn't load the picture anymore, I would be extremely appreciative, since we
need to upgrade to Office/2000 at least!

Diana Bodell

 

[Graham Mayor]

It should work fine in every version of Word from 97 to date, assuming of
course you have the tools > options > view > picture placeholders unchecked.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[robw]

Graham,
Thanks...yes...that does the trick. I was originally merging directly to a
(virtual) printer, rather that to a merge file followed by a doing a global
"field update" . I've not had to do that before when doing "simple" textual
merging. Is the reason for my problem this time the "nested fields" nature
of this particular merge or simply because it involves including pictures ? (
I must experiment sometime to find out)

Thanks again
Rob

 

[DBodell]

Graham, I must thank you for your reply. I had been having terrible problems
with this function which I had had all set up and working for years on Word
97 (thanks to Cindy Meister!!). Your response made me go back and revisit it
again. Turns out there was a problem only on my development machine and not
on the machine from which we print the signs! I can safely report that it
does work on Word 2000. Still don't know what is wrong on my machine but that
is another problem for another day.

BTW, it is really nice to write a macro that automates the CTRL+A and F9
functions when the mail merge document is loaded. I did that for my users and
the macro also automatically sends the merged result document to print
preview for them after updating all the fields. I love recording macros for
stuff like this because I am not a VBA programmer and it allows me to get
things going without having to be one.

Thanks again,
Diana Bodell