Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

Merging between Access and Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lace - 11 Oct 2007 20:30 GMT
I am doing a merge from Access into a Word document.  The graphic fields in
Access are showing up as "151C1D00" after I merge into word.  Does anyone
know how can I have the pictures show in word after I merge?
Peter Jamieson - 12 Oct 2007 17:36 GMT
You can't merge the image data in access directly into Word. The best you
can do is maintain copies of the images in files outside the database in a
format that Word can insert using an INCLUDEPICTURE field, and keep enough
information in the record that the image comes from to build the file name
of the image. For example, if each record has a unique numeric key called ID
wwith values 1,2,3, etc., then you might save each image as

c:\myimages\img1.jpg
c:\myimages\img2.jpg
c:\myimages\img3.jpg

etc., then use the following nested field in Word:

{ INCLUDEPICTURE "c:\\myimages\\img{ MERGEFIELD ID }.jpg" \d }

All the {} have to be the special field code braces you can insert using
ctrl-F9.

Then you may also have to output your merge to a new document, select it
all, and press F9 to update the fields.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I am doing a merge from Access into a Word document.  The graphic fields in
> Access are showing up as "151C1D00" after I merge into word.  Does anyone
> know how can I have the pictures show in word after I merge?
 
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.