Hi Peter,
One of the solutions could be like this:
- merge letters to the new document (to create a plain Word document)
- scan the excel file for picture file names (either using Excel Automation or import it to VFP cursor and scan the cursor);
- use Word Automation while scanning the excel file and:
- search for the line containing the file name
- if found, insert a picture from this file
....
Hope you got the idea, Good Luck
>I create an excel file as a data doc for a word mailmerge. I all works fine except:
>
>2 of the fields contain the names (with complete path) of photos i want to insert into the documents.
>
>It is alist of classmates of a high school from 1956 and each mate has a pictur from the yearbook plus some submitted recent photos. they should be printed in the mailmerge as phots rater filenames
>
>how could I accomplish this at the moment it looks like this:
>
http://www.cortiel.com/sshs/sample1.png>
>I want it to look like this:
>
http://www.cortiel.com/sshs/sample2.png>
>Any ideas??
>
>
>Thanks
>
>Peter