 |
 | 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 / January 2005adding pictures in a mail merge
Hi, i have a mail merge document, i have added the includePicture field and then put the link from the excel file into it, the excel file again has link to the picture (pics/myPicture.gif) when it completes the merge if you look at the code it is correct (it shows the correct path to all the different pictures...) .... but all the dynamic pictures are the same one... the first one in the list to be accurate.... i can change them to the correct picture my doing an edit field and after it shows the field bos just clidking ok in it...but i cant do that for every picture.... (theres over a 100..) any ideas how i can refresh (or something like that) all the field tags so they show the right picture... thanks Merge to a new document, select all (CTRL+A) then F9 to update.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi, i have a mail merge document, i have added the includePicture > field and then put the link from the excel file into it, the excel [quoted text clipped - 11 lines] > > thanks Even better, record a macro for yourself doing exactly as Graham just suggested. Then run that macro on the document open event (you have to put this in with VBA code). I did this on a sign program that I wrote where I load a picture of the plant that the sign is for (I work for a garden center). In order to keep my users from having to remember the CTRL+A and F9 stuff, I recorded and saved the macro to do this and then also to go to print preview automatically. All the users see is the document starting up, doing the mail merge, updating each of the fields and then print previewing in a matter of seconds. It works like a charm! If you need help with it, feel free to write me privately: dbodell@thegrowingplace.com Diana Bodell > Merge to a new document, select all (CTRL+A) then F9 to update. > [quoted text clipped - 13 lines] > > > > thanks Oops, now that I have seen your great website with all the macros on it, I realize that you have written the macro I was talking about! Thanks again, Graham. > Merge to a new document, select all (CTRL+A) then F9 to update. > [quoted text clipped - 13 lines] > > > > thanks
|
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.