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 / November 2003

Tip: Looking for answers? Try searching our database.

Access OLE object fields in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thorpe - 25 Nov 2003 16:43 GMT
I have an access database table that has n OLE Object filed that stores
images. This works ok
I want to do a mail merge from the access database table when I set up the
word mail merge all the fileds come across but the OLE object field fails to
show the images.

can this be done via a mail merge

any thanks would be great
Peter Jamieson - 25 Nov 2003 19:51 GMT
Unfortunately you have to export each image from Access into a separate file
then use an { INCLUDEPICTURE }  field in Word to insert it. TYpically you
use some data item in the record to construct a name for the file, e.g.
suppose you have a column called K containing a number 1,2,3, then you might
export your pictures to files called c:\pic\1.jp, c:\pic\2.jpg etc. and use

{ INCLUDEPICTURE "c:\\pic\\{ MERGEFIELD K }.jpg }

to include it during the merge.

If you use a DDE connection to Access you /might/ be able to do the export
as an integral part of the merge operation rather than a separate step by
writing an Access VBA function to export the image from a specific record,
calling that function in an Access query, and using the query as your data
source. I have tried something similar and it does seem to work for small
data volumes.

--
Peter Jamieson - Word MVP

> I have an access database table that has n OLE Object filed that stores
> images. This works ok
[quoted text clipped - 5 lines]
>
> any thanks would be great
 
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.