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 / May 2006

Tip: Looking for answers? Try searching our database.

How do I insert pictures into mail merge doc from a database filen

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alan - Love in Action, Uganda - 18 May 2006 07:18 GMT
I have an access database with names & addresses and a field with the
filename of a picture. I want to send a mail merge letter to everyone by
email with each seeing the picture whose file name is in the database. Can
this be done?
Thanks

I am using Office 2003
Peter Jamieson - 18 May 2006 11:31 GMT
It is usually feasible as long as Word knows how to insert the type of
picture you have (.jpg etc.), but there are often problems.

To insert the picture, try using a nested INCLUDEPICTURE field such as

{ INCLUDEPICTURE "{ MERGEFIELD picturefilename }" }

where picturefilename is the field containing the picture file name, and the
{} are inserted using ctrl-F9.

You may also need to
a. double up the backslashes in the picture path names in your database
(although off the top of my head, I don't think you do)
b. check Word Tools|Options|Print|Update Links/Update fields
c. uncheck Word Tools|Options|general|Web options|Files|Update links on
save
d. use the \d switch, and possibly the graphic converter switch in the
INCLUDEPICTURE field (see Word help for details)

Peter Jamieson
>I have an access database with names & addresses and a field with the
> filename of a picture. I want to send a mail merge letter to everyone by
[quoted text clipped - 3 lines]
>
> I am using Office 2003
 
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.