Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Advance Mail Merge using Graphics
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Advance Mail Merge using Graphics
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"} whe '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] ------------------------- "K-5 Tech Teacher" K-5 Tech wrote in message ... 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! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Advance Mail Merge using Graphics
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 "macropod" wrote in message ... 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"} whe '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] ------------------------- "K-5 Tech Teacher" K-5 Tech wrote in message ... 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphics in mail merge Word 2000 | Mailmerge | |||
Mail Merge in Graphics | Mailmerge | |||
Mail merge graphics | Mailmerge | |||
How do I Mail Merge graphics into a document | Mailmerge | |||
Graphics in Label Mail Merge | Microsoft Word Help |