I hoped for a simpler solution!
Thanks Yuri,
Peter
>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
Peter Cortiel