Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2007

Tip: Looking for answers? Try searching our database.

Advance Mail Merge using Graphics

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
K-5 Tech Teacher - 19 Apr 2007 14:10 GMT
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 - 19 Apr 2007 15:34 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.