I'm using Office 2003.
I have an Excel file that I use to create nametags for activities for my
students. I know how to use the Mail Merge feature in Word. Let's say,
though, that I have four graphics to use on the nametags: the stars, the
squares, the circles, and the triangles. In my Excel file, I assign one of
those shapes in a field to each student (i.e. Johnny is a star, Sarah is a
circle, Henry and Beth are triangles, etc.)
I currently have to go through the merge/print process four times -- once
for each shape.
Is there a way to direct Word to print the Star graphic on the nametag if
the field for a student says Star, print the Circle graphic if it says
Circle, etc.?
Thanks for your help!
Hi K-5 Tech Teacher,
Assuming the name of each picture (star, square, circle, triangle) is on the same row as the corresponding student name, you could
use an INCLUDEPICTURE field coded as:
{INCLUDEPICTURE "C:\\Filepath\\{MERGEFIELD PicName}.jpg"}
where:
'C:\\Filepath\\' denotes the full path to the folder holding image files for the star, square, circle & triangle - note the double
'\\' for the folder separators
'PicName' is your mailmerge field name
and
'.jpg' is the filetype, which might also be '.gif', '.tif', etc.
Cheers

Signature
macropod
[MVP - Microsoft Word]
-------------------------
> I'm using Office 2003.
>
[quoted text clipped - 13 lines]
>
> Thanks for your help!
Miles - 19 Apr 2007 19:40 GMT
There's also a Word add-in that automates graphic/picture mail merge,
available at http://onmerge.com
The add-in avoids the manual coding, gets rid of all the resizing issues,
and lets you do an image merge straight to the printer instead of the
annoying "Merge to Document, Ctrl-A, F9, resize, Print" drill that
IncludePicture typically requires.
Even if you don't want an add-in, the site has a useful article that
explains the details and gotchas you need to know about to successfully use
IncludePicture (blue box in the left column about 1/4 down the page).
I hope this helps -- Miles
> Hi K-5 Tech Teacher,
>
[quoted text clipped - 30 lines]
>>
>> Thanks for your help!