Mailmerge images stored in Access as OLE Objects

I need to do a mailmerge in word with a different employee photo per record, but I don't have access to the original images, but they're in an Access database table stored as OLE Objects. Is it possible to link the Mailmerge to them, or extract these embedded photos to a shared drive so I can include them in the mailmerge?
LVL 1
DavisroBudget AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
I have never seen a mail merge that included images...
(but I may be wrong)

You can extract the OLE images with his poplar utility:
http://www.lebans.com/oletodisk.htm

Also keep in mind that the same "Mail Merge" functionality can be done in Access alone, ...and since the images are already in Access this may be easy.

If the ate is already in Access as well hen this is easier still...

Even if the data is in Excel, ...you can still create a "Report" in Access that will perform as a "Mail Merge".

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
...but the simulated mail merge requires some additional work on your part...

So try extracting the images to a disk file, ...then use a system like the attached db to "Link" to the images.
AccessBasicLinkFormReportImages.mdb
DavisroBudget AnalystAuthor Commented:
Thank you, Sir!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.