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 / February 2008

Tip: Looking for answers? Try searching our database.

Word 2007 - merge image data from Sql datasource

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mort Strom - 19 Feb 2008 08:08 GMT
Hi all,

I am creating a mail merge in Word 2007 and wondering if it is possible to
merge pictures.  My data source points to a SQL Server and I can
successfully capture desired text fields.  However, I don't know how to
insert the picture data.  The image data coming from my data source is the
raw image itself.

Can pictures be included in a mail merge with data coming from SQL?

Thanks for any direction,
Mort
Peter Jamieson - 19 Feb 2008 09:15 GMT
Unfortunately not. You can only really insert them by using an
INCLUDEPICTURE field, and that has to get the picture from an ordinary image
file such as a .jpg file that resides in a file system somwhere. So you
really have to extract each picture to a file before you merge, and ensure
that you can construct the picture's path name from the data in the relevant
record (i.e. typically you need to name the picture files with the primary
key data). You could probably extract them on the server (and if it's on a
WIndows network, put them in a folder on the netwrok somewhere) using a
Stored Procedure but because it's at least /hard/ to use a stored procedure
as a data source (and I don't think it is actually possible in current
versions of Word) you still have to do it before the merge.

Signature

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

> Hi all,
>
[quoted text clipped - 8 lines]
> Thanks for any direction,
> Mort
 
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.