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 / July 2004

Tip: Looking for answers? Try searching our database.

Access OLE to Word  Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DeniseT - 21 Jul 2004 23:38 GMT
Hi Everyone,

I am having a problem merging an Access database file,
which has an OLE image field, into a Word mail merge doc.

When I am using MS Word's Mail merge, the Access OLE
image does not display in the Word merged document as an
image. Instead, it is displayed as an icon.

How can I display the OLE image in the merged document as
an image?

Thank you in advance.
Denise
Peter Jamieson - 23 Jul 2004 10:11 GMT
There isn't a simple way to display OLE objects (even simple ones such as
images) in a Word mailmerge. The only straightforward way to do it is to
export all the images you need to separate files, using some name that
associates them with the record they came from, then use an INCLUDEPICTURE
field to include them.

For example, if each record has a key called k with values 1,2,3 and all the
images are .jpgs you could export all the images to

c:\myimages\image1.jpg
c:\myimages\image2.jpg
c:\myimages\image3.jpg
etc.

then use a nested field such as

{ INCLUDEPICTURE "c:\\myimages\\image{ MERGEFIELD k }.jpg" }

where all the {} are the special field braces you can insert using ctrl-F9

Signature

Peter Jamieson

> Hi Everyone,
>
[quoted text clipped - 10 lines]
> Thank you in advance.
> Denise
 
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.