need help merge jpg's from excel to word
Hi,
I am trying to mail merge jpg files from excel to word.
I have followed the steps below:
1.Created the fields in excels with the jpg name including the .jpg
2.Created the field in word including
{IncludePicture " C:\\Documents and Settings\All Users\Documents\My
Pictures\Sample Pictures\\{ MERGEFIELD picture }" \d}
But the result I am getting is a pictuer fram with an red X at the top left
see below
I have checked the location again and this is the right file location
Can you please assist me with that
Thank you
hello Dave,
"Dave Peterson" wrote:
Say you have your list of images in A1:A99.
You can use a formula in B1 (and copy down to B99):
=a1&".jpg"
Alain wrote:
Hi,
Someone please tell me how I can set up my Excel document to automatically
add the ".jpg" extension at the end of every image name, which I can then use
in a mail merge catalog (Publisher) instead of physically having to type it
at the end of every word. Thank you in advance.
Al
--
Dave Peterson
|