Advance Mail Merge using Graphics

[K-5 Tech Teacher]

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!

 

[macropod]

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

 

[Miles]

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,

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
--
macropod
[MVP - Microsoft Word]
-------------------------

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!