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 / January 2007

Tip: Looking for answers? Try searching our database.

Images MailMerged from Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jbrzez - 30 Jan 2007 13:21 GMT
Here is a question I put in the Excel Discussion Group:
I have an Excel file (for a family directory) that contains normal field
(text-based) entries and alos I have added in some images.  I am using Mail
Merge in Word to create a directory and the text fields come over but not the
images contained in the image field.  What do I need to do to the images in
Excel to have both Excel recognize them and be usable in other applications?

Is there anything on the Word side that I can do to make this merge
smoother/cleaner?
Doug Robbins - Word MVP - 30 Jan 2007 15:51 GMT
See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Here is a question I put in the Excel Discussion Group:
> I have an Excel file (for a family directory) that contains normal field
[quoted text clipped - 9 lines]
> Is there anything on the Word side that I can do to make this merge
> smoother/cleaner?
jbrzez - 30 Jan 2007 16:07 GMT
The newsgroup has done wonders for me so I will keep the issue in here.
I don't have full Internet access here at work so I can't access the site
you listed.  Can you outline it as a response here or cut and paste the info
into the response?

> See the "Graphics from data base" item under the "Special merges" section of
> fellow MVP Cindy Meister's website at
[quoted text clipped - 14 lines]
> > Is there anything on the Word side that I can do to make this merge
> > smoother/cleaner?
Doug Robbins - Word MVP - 30 Jan 2007 18:19 GMT
Word cannot merge a graphic or OLE-object directly from a database because
it does not understand the type of data the database sends across (long
binary). Therefore, you have to workaround this obstacle.

 1.. Save the graphics files in a folder (directory) on a drive
 2.. Place the file name (or path information) in a field in the database
 3.. Reference the graphic file information by nesting the merge field in
an IncludePicture field.
 Example: { IncludePicture "C:\\Data\\Pics\\{ Mergefield Signature \*
upper }" }
 4.. You must now merge to a new document.
 5.. Update the field display so that each record shows the correct
picture. (You can press Ctrl+A to select the entire document, then F9 to
update the fields.)
Note the double backslashes in the example, as well as the double-quotes.
Both are necessary if the field is to work correctly.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> The newsgroup has done wonders for me so I will keep the issue in here.
> I don't have full Internet access here at work so I can't access the site
[quoted text clipped - 24 lines]
>> > Is there anything on the Word side that I can do to make this merge
>> > smoother/cleaner?

Rate this thread:






 
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.