 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2003Merge Pics and Data in Word97 from Excel 97 ??
Hi Can you help with this - I can merge data from Excel97 into Word97 no probs - but whatever I do I cannot get pictures (jpegs etc) to merge. I can see the place holder after merging but no pictures. I have looked in the knowledge base for help - see Microsoft Article 114306. It does not work for me. Perhaps someone can point me somewhere to see a working example or send me a working example so that I can see how its done / or step by step instructions - let me know and I will email you for an example. Hope you can help Thanks Ray Hi Ray, > Can you help with this - I can merge data from Excel97 > into Word97 no probs - but whatever I do I cannot get > pictures (jpegs etc) to merge. There are instructions on my website. I'm not sure what you mean by the "picture placeholder", but you do have to remember to Ctrl+A, F9 in the merge result document to force the fields to update. Cindy Meister  SignatureINTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi. These instructions work OK, as long as you DON'T save the merge document. I'm using Word 2002. When I save the merge document, the MERGEFIELD information is removed and the actual data from the first merge record (the path & filename) are saved in its place. Is there a way to save the document to reuse at a later date? Thanks! Pat Hi Pat, > These instructions work OK, as long as you DON'T save the > merge document. [quoted text clipped - 7 lines] > Is there a way to save the document to reuse at a later > date? Now, this is also something I've never seen before. So I need to ask some follow-up questions: 1. Are we talking about the main merge document, or the merge result document? 2. Use Alt+F9 to look at the IncludePicture field that should be maintaining the proper link. Has anything about it been changed (is it still there at all)? If it's been changed, please describe what you see very exactly or copy/paste the content of an unchanged field and a changed field so that we can see what's been done. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) >-----Original Message----- >Hi Pat, [quoted text clipped - 36 lines] >. >Cindy, I have followed then instructions as on your web site - still does not work and the error is "file name not specified" Please note that I am using excel as the data source. The photo field in the spreadsheet points to the file.jpg in the same folder as the spreadsheet. By place holder I mean a box does appear which should be the picture, but it does not appear!! Is there anywhere I can download a sample so that I can test an example that works !! Hope you can explain Thanks Ray > I have followed then instructions as on your web site - > still does not work and the error is "file name not [quoted text clipped - 3 lines] > By place holder I mean a box does appear which should be > the picture, but it does not appear!! Check in Tools/Options/View whether "Picture placeholder" has been activated. If it has, turn it off and you should be OK? Cindy Meister SignatureINTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) >-----Original Message----- >> I have followed then instructions as on your web site - [quoted text clipped - 21 lines] >. >Hi - Thanks but this was turned off (not ticked) - I have shown below the formula entered into the word document and the result - hope this helps ?? I am using Excel 97 as the database: Formual: {INCLUDEPICTURE "C:\\Documents and settings\\RKING\\Desktop\\test\\{MERGEFIELD Photo}"} Results in: Error! Filename not specified. The spreadsheet, the word document and the images are all store in the same folder "test" My spreadsheet looks like : Name Description Price Photo Bell Alarm Clock 25 Chubb.jpg candle Holder Holds candles 35 tank blaze.tif Cash Box with lid 45 C:\\Documents and Settings\\RKING\\Desktop\\test\\Chubb.jpg As you can see, I have tried it with just a file name and also with a path - still does work for me Hellllllllppppppppppppp!! >1. Are we talking about the main merge document, or the >merge result document? the main merge document >2. Use Alt+F9 to look at the IncludePicture field that >should be maintaining the proper link. Has anything about it >been changed (is it still there at all)? If it's been >changed, please describe what you see very exactly or >copy/paste the content of an unchanged field and a changed >field so that we can see what's been done. Original text of the merge fields (before saving) {INCLUDEPICTURE {MERGEFIELD "PICPATH"} \*MERGEFORMAT} Text of the merge field AFTER saving. {INCLUDEPICTURE "042.JPG" \*MERGEFORMATINET} To note: The contents of the "PICPATH" field is: c:\\dev\\pictures\\042.jpg And, I'm using a DBF as the merge source. Thanks for the help. Pat Hi Pat, > Original text of the merge fields (before saving) > {INCLUDEPICTURE {MERGEFIELD "PICPATH"} \*MERGEFORMAT} > > Text of the merge field AFTER saving. > {INCLUDEPICTURE "042.JPG" \*MERGEFORMATINET} Yep, this is the problem: MergeformatINET. Go to Tools/OPtions/General/Web options/Files and deactivate the checkbox about updating file links when saving. This is only supposed to kick in when saving to HTML format, but it's broken in Word 2002 and triggers for normal documents, as well. Now you should be able to save with impunity :-) Cindy Meister SignatureINTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Cindy, That did it! Thank you so much!!!!! Pat >-----Original Message----- >Hi Pat, [quoted text clipped - 26 lines] > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.