Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JeffC JeffC is offline
external usenet poster
 
Posts: 5
Default Use mail merge to insert image using path in datasource

Can you use the mail merge function to insert an image into the word
document? In other words, if my data source has
C:\Administrator\Desktop\image.jpg in one of the fields, is there a way to
force word to bring in the image?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Use mail merge to insert image using path in datasource

You will need to modify the data source so that the data is in either of the
following formats

C:/Administrator/Desktop/image.jpg

C:\\Administrator\\Desktop\\image.jpg

What is the data source? For any Office data source, it should be possible
to do this using EditReplace

If it is something that does not allow you to use that method, use the
original data source with a directory type mail merge in the main document
of which you have a one row table into the cells of which you insert the
mergefields. When you execute that merge to a new document, that document
will contain a table with a row of data for each record in the data source.
You can then use EditReplace on that document and then insert a row at the
top of the table into which you insert the names of the mergefields that you
want to use. Then save and use that document as the data source for the
merge that you originally wanted to create.

--
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, originally posted via msnews.microsoft.com
"JeffC" wrote in message
...
Can you use the mail merge function to insert an image into the word
document? In other words, if my data source has
C:\Administrator\Desktop\image.jpg in one of the fields, is there a way to
force word to bring in the image?


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Use mail merge to insert image using path in datasource

Hi JeffC,

Yes, you can do this without modifying the data path. You can use a field coded as:
{IF {INCLUDEPICTURE "{IF TRUE «Image»}"} {INCLUDEPICTURE "{IF TRUE «Image»}"}}
where 'Image' is the field name for your image data.

Unlike the method Doug suggests, the above approach avoids the need to refresh the links after the merge, plus it unlinks the images
from the source files, which you'd need to do anyway before sending the merged output to anyone else.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[Microsoft MVP - Word]


"JeffC" wrote in message ...
Can you use the mail merge function to insert an image into the word
document? In other words, if my data source has
C:\Administrator\Desktop\image.jpg in one of the fields, is there a way to
force word to bring in the image?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 - merge image data from Sql datasource Mort Strom Mailmerge 1 February 19th 08 09:15 AM
Custom mail merge datasource Kelly Leahy Mailmerge 2 March 17th 06 03:04 PM
Datasource Path LuckyLady Mailmerge 2 October 3rd 05 05:50 PM
Can I Mail Merge from SQL Database without an odc datasource? Robert Jones Mailmerge 2 June 1st 05 03:27 PM
Mail merge field different in datasource & insert a field menu Silvs Mailmerge 1 April 22nd 05 06:18 AM


All times are GMT +1. The time now is 08:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"