 |
 | 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 / Excel / New Users / October 2007Include a Picture Field
I have data in excel from which i'm creating many mail merges - Included in each record/row is a field containg the clients passport photo which I would like to include in the mail merge Any Ideas? I cant use Access because it's not on most machines but if ness i can easily move the data source from excel to MS Word table What I've done in such cases is to include a mergefield with just the filename of the photo, which is stored elsewhere. Then I use an IncludePicture field with the full path of the folder where the folders are stored, using the merge field as the last portion of that path. If the photo itself is actually stored in Excel (is that possible?), then a mergefield referencing that field should bring in the photo.  SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. > I have data in excel from which i'm creating many mail merges - Included in > each record/row is a field containg the clients passport photo which I would [quoted text clipped - 4 lines] > I cant use Access because it's not on most machines but if ness i can easily > move the data source from excel to MS Word table They are currently stored in XL but i'll give that a try thanx > What I've done in such cases is to include a mergefield with just the > filename of the photo, which is stored elsewhere. Then I use an [quoted text clipped - 16 lines] > easily >> move the data source from excel to MS Word table See http://www.gmayor.com/mail_merge_graphics.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > They are currently stored in XL but i'll give that a try thanx > [quoted text clipped - 25 lines] >>> I cant use Access because it's not on most machines but if ness i >>> can easily move the data source from excel to MS Word table |
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.