Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
McFox McFox is offline
external usenet poster
 
Posts: 7
Default Importing variable images into a mail merge

Using Word and Excel 2003, I need to import a number of different jpeg files
into the mail merge.
Ideally the image would be a field and then linked into the main document.
Is this possible, or alternatively could Access be used for the same
purpose? If the latter, how do you place a jpeg file in Access, to pull
through into a Word document?

Thanks.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Importing variable images into a mail merge

Save each jpg as a separate file with a pathname that can be constructed
from data in your Excel sheet.

e.g. if all your jpgs are in

c:\myjpegs\

then you can put the file name (mypic1.jpg etc.) for each image in a column
in the appropriate row in Excel. Let's call the column "jpgfile"

Then use the following nested Word fields in your Mail Merge Main Document:

{ INCLUDEPICTURE "c:\\myjpegs\\{ MERGEFIELD jpgfile }" }

(all the {} have to be the special field codes you can enter using ctrl-F9.
notice that the folder pathname backslashes are doubled up. Ensure you don't
have any spaces that should not be in the full path name of the file)

Merge to a new output document, select it (e.g. ctrl-A) and press F9 to
update all the images.

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

"McFox" wrote in message
...
Using Word and Excel 2003, I need to import a number of different jpeg
files
into the mail merge.
Ideally the image would be a field and then linked into the main document.
Is this possible, or alternatively could Access be used for the same
purpose? If the latter, how do you place a jpeg file in Access, to pull
through into a Word document?

Thanks.


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
Mail merge into columns with variable length data? Nigel Molesworth[_2_] Page Layout 11 January 21st 08 09:45 PM
Inserting variable images into a mail merge Kamitsukenu Mailmerge 6 January 3rd 07 03:13 PM
Mail Merge with variable lines per page aps Mailmerge 3 October 6th 05 02:11 PM
Mail Merge with variable lines per page aps Microsoft Word Help 0 September 30th 05 09:00 AM
Mail Merge - importing documents Bevan Microsoft Word Help 2 January 25th 05 03:05 AM


All times are GMT +1. The time now is 03:19 AM.

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"