 |
 | 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 / March 2004merge a photo from access database into word
Is it possible to merge a photo that is in an access table database into a word document using mail merge? When I attempt it, it merges a number only? Thank you! Jon See the "Graphic from a database" item under the "Special merges" section of fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindymeister/MergFram.htm  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Is it possible to merge a photo that is in an access > table database into a word document using mail merge? > When I attempt it, it merges a number only? Thank you! > > Jon Thank you for the reply, unfortunately it hasn't worked. I have Office XP. When i follow the instructions for Includepicture, immediatly after I insert the field everthing disappears. Additionally, I have tried using the insertpicture option but I get an error messsage when i merge. In the access table field i have the name of the picture and have its properties set to text, Is this correct for the merge. Thank you Jo ----- Doug Robbins - Word MVP - DELETE UPPERCA wrote: ---- See the "Graphic from a database" item under the "Special merges" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/MergFram.ht -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis Hope this help Doug Robbins - Word MV "jon" <anonymous@discussions.microsoft.com> wrote in message news:05d101c3ff15$0b2f2120$3501280a@phx.gbl.. > Is it possible to merge a photo that is in an acces > table database into a word document using mail merge > When I attempt it, it merges a number only? Thank you >> Jon Yes, in the database you will need as a minimum, the filename for the picture. If that is all that you have there, you will need to supply the path in the Mergefield and note that the path separators must be doubled \\ Did you follow Step 5 of Cindy's instructions - updating the fields in the document after the merge? Also, you must use Ctrl+F9 to insert each pair of field delimiters { }. Ordinary curly brackets will not work. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > > Thank you for the reply, unfortunately it hasn't worked. I have Office [quoted text clipped - 30 lines] > > When I attempt it, it merges a number only? Thank you! > >> Jon I've read this thread with great interest as the end result originally requested is precisely what I need to achieve. However, please pardon this ridiculous question. How do you get the 'IncludePicture' field in to the document in the first place, to then nest the mergefield? (as suggested in Cindy Meister's site). 'Help' suggests just 'Insert/ Picture from file' and link to file, but then how do I see the code and adjust it? A very new area for me, so my apologies for the daft query! I'm stuck with Office '97 by the way. Cheers FH >-----Original Message----- >Yes, in the database you will need as a minimum, the filename for the [quoted text clipped - 25 lines] >> >> http://homepage.swissonline.ch/cindymeister/MergFram.htm >> -- >> Please post any further questions or followup to the newsgroups for [quoted text clipped - 12 lines] > >. Use Alt+F9 to toggle on and off the field codes. Or use Ctrl+F9 to insert and empty pair of field delimiters { } then manually enter the text INCLUDEPICTURE etc. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > I've read this thread with great interest as the end > result originally requested is precisely what I need to [quoted text clipped - 85 lines] >> >>. Many thanks! It's all working now. It baffles me how the refresh works AFTER the merge, but it works, and that's good enough for now! F >-----Original Message----- >Use Alt+F9 to toggle on and off the field codes. Or use Ctrl+F9 to insert [quoted text clipped - 92 lines] > >. Thank you for your patience. I have attempeted each. This is the path I have input. {IncludePicture "C:\\fe\\{MERGEFIELD Equip_Recommendation}"} In the Access table field of Equip_Recommendation I have my photos identified as test1.jpg and test2.jpg and so on When I use ctrl+a and F9 it returns this error message. Error! Bookmark not defined. When I attempt to insert the mergefield with the includepicture command, as soon as I hit enter to insert the mergefield the enire line disappears (and does not execute). Thank you again! >-----Original Message----- >Yes, in the database you will need as a minimum, the filename for the [quoted text clipped - 25 lines] >> >> http://homepage.swissonline.ch/cindymeister/MergFram.htm >> -- >> Please post any further questions or followup to the newsgroups for [quoted text clipped - 12 lines] > >. I am not sure what I was doing wrong but I think I have accomplished it. There is just one more challange, The same photo is in each merged document. The only way to change this is to ctrl +a and f9- however this just duplicates the problem with the other records. Is there a way to have the correct picture with each merged record? If not do you have any other suggestions? Thank you again!!!!!!! >-----Original Message----- >Yes, in the database you will need as a minimum, the filename for the [quoted text clipped - 25 lines] >> >> http://homepage.swissonline.ch/cindymeister/MergFram.htm >> -- >> Please post any further questions or followup to the newsgroups for [quoted text clipped - 12 lines] > >. Hi Jon, What is the problem with the other records? SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP >I am not sure what I was doing wrong but I think I have > accomplished it. There is just one more challange, The [quoted text clipped - 82 lines] >> >>. The same photo is merged into each record. If I update with F9 it changes the photo for the record but it changes it to the same photo for all records. Thank you, Jon >-----Original Message----- >Hi Jon, [quoted text clipped - 61 lines] >>>> section of >>>> fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindymeister/MergFram.htm >>>> -- >>>> Please post any further questions or followup to [quoted text clipped - 21 lines] > >. You have to select all CTRL+A then F9 to update all the images - see http://www.gmayor.com/mail_merge_graphics.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > The same photo is merged into each record. If I update > with F9 it changes the photo for the record but it [quoted text clipped - 85 lines] >> >> . Thank you, I didn't understand that you couldn't do this in the individual record view. However when I convert the entire document it is placing a picture in records that don't have one listed in the merge field. It basically cycles through the pictures and repeats the cycle. How do I correct this? Thank you!!!! >-----Original Message----- >You have to select all CTRL+A then F9 to update all the images - see [quoted text clipped - 68 lines] >>>>>> section of >>>>>> fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindymeister/MergFram.htm >>>>>> -- >>>>>> Please post any further questions or followup to the [quoted text clipped - 16 lines] > >. I don't understand what you mean. If you insert the images as described in the web page I posted, then if there are no images to insert it won't insert them. You have to update the new document after you run the merge - as explained. What cycle is there to repeat? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Thank you, I didn't understand that you couldn't do this > in the individual record view. However when I convert the [quoted text clipped - 104 lines] >> >> . Sorry for the confusion, There are a total of 15 records, three of which have photos. I followed the procedures as recommended. after the merge and update all 15 records have photos attached. record 1,4,7,10,13 all have the photo associated with record 1. record 2,5,8,11,14 have the photo associated with record 2, and record 3 has the remaining. Jon >-----Original Message----- >I don't understand what you mean. If you insert the images as described in [quoted text clipped - 87 lines] >>>>>>>> merges" section of >>>>>>>> fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindymeister/MergFram.htm >>>>>>>> -- >>>>>>>> Please post any further questions or followup to the [quoted text clipped - 18 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.