View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron[_2_] Ron[_2_] is offline
external usenet poster
 
Posts: 2
Default 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