corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel - mail merge » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help

Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

topshot_2k

posted on 10th Sep 06 at 19:33

up


topshot_2k

posted on 7th Sep 06 at 21:20

yes i have mate, cant see why its not working as it pics all his deatilsd up but it seems the inlcudepicture function isnt working


Melville

posted on 7th Sep 06 at 20:29

are you putting c:\johnsmit.jpg?


topshot_2k

posted on 7th Sep 06 at 17:05

ok tried all that and i get all the details in the word doc but where the photo should be is just says C:johnsmith.jpg instead of the piccy. any ideas??


topshot_2k

posted on 6th Sep 06 at 18:58

cool mate thanks i'll give it ago at work tomoz and post if all goes ok.


mark87

posted on 6th Sep 06 at 18:38

Use a field for the image path, eg. C:\johnsmith.jpeg.

In Word, where you want the picture to be add a field like this (you will need to toggle field codes on/off, I don't have Word here so can't remember exactly (there's a button on the Mail Merge toolbar)...

{ IncludePicture "{ MERGEFIELD Image }" \d }

...where Image is the name of the field.

Let me know if it's goes okay!


topshot_2k

posted on 6th Sep 06 at 17:03

Right im in the process of making some ID badges for students where i work. I have all of their address deatils in an excel sheet and want to put their Student ID and photos in another.

So I have:

Table 1:
Name Surname Address
john smith etc


Table 2:
Student ID Photo
001
002

can i insert the images into the table directly or do i need to enter the photo field as a pointer to the image e.g. C:\johnsmith.jpeg


once i have the photos in the table i need to mail merge table 1 and 2 together in word, i can get the written details but how can i get the photos to merge??

thanks in advance


ohh and its in excel 2003:thumbs: