Posting Photos

[Dave]

I need help in inserting photos into a mail merged documents.
I have a multi page mailmerge Word document that I would like to insert
photos into several different pages.
I am using excel to store my data on each student and a file folder with all
student folders. Each photo is given a file number such as "tray1234IMGo1" I
show this file number in the Excel worksheet.
Many thanks for any help!

 

[GTS]

I need help in inserting photos into a mail merged documents.
I have a multi page mailmerge Word document that I would like to insert
photos into several different pages.
I am using excel to store my data on each student and a file folder with all
student folders. Each photo is given a file number such as "tray1234IMGo1" I
show this file number in the Excel worksheet.
Many thanks for any help!

You can use an Includepicture field to add photos. The photo file name is
the file number mergefield:

{ INCLUDEPICTURE "C:\\PICTURES\\{ MERGEFIELD FILENUMBER }.jpg" }

However this assumes that all pictures are in one folder ( PICTURES). If the
student folders are all named the same as the file numbers you could try
using the same file number in the path but no idea if it would work:

{ INCLUDEPICTURE "C:\\FILE FOLDER\\{ MERGEFIELD FILENUMBER }\\{ MERGEFIELD
FILENUMBER }.jpg" }

The curly braces are added using CTRL-F9 if hand-typing the above.
Alternatively use insert to insert a linked picture and replace the file
name with your mergefield thus:

"INCLUDEPICTURE "FileName" [Switches ] }
Inserts the specified graphic.

To insert an INCLUDEPICTURE field, point to Picture on the Insert menu,
click From File, click the arrow next to the Insert button, and then click
Link to File"

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_graphics.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Dave]

I thank you for your direction and assistance, however I am still having a
problem getting it to work.

Here is what I ended up with:
{INCLUDEPICTURE "d:my documents\my data sources\cadet photos\{MERGEFIELD
"Photo_ID"}}

All the student photos are stored in the "cadet photos" file and the file
names are shown in my exel spreadsheet under the column headed "Photo ID"

Any other help will be appreciated.

 

[Graham Mayor]

The correct syntax would be
{INCLUDEPICTURE "d:\\my documents\\my data sources\\cadet
photos\\{MERGEFIELD
"Photo_ID"}"}
assuming the path to the files is correct. If the Photo_ID field does not
contain the full filename with extension, you will have to add the extension
also, eg:
{INCLUDEPICTURE "d:\\my documents\\my data sources\\cadet
photos\\{MERGEFIELD
"Photo_ID"}.jpg"}
Merge to a new document, select all (CTRL+A) then F9 to update.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>