how do I use mail merge on pre-printed award certificate

[neesiej]

I have a pre-printed award certificate that I need to merge w/an Excel
spreadsheet that has award recipients names, years of service, etc. How Do I
do this? I am using MS Word 2000. Thanks

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?bmVlc2llag==?=,

I have a pre-printed award certificate that I need to merge w/an Excel
spreadsheet that has award recipients names, years of service, etc. How Do I
do this? I am using MS Word 2000.

I'm not sure what you're asking? Have you ever used mail merge before? If not,
read what's in the Help files, then look at the tutorial at word.mvps.org.

If you have done mail merge before, please describe in more detail what's
stimying you this time.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[neesiej]

Thanks for responding. Yes, I do mail merge to create letters, but have not
used an Excel spreadsheet to merge/print information onto a preprinted
(volunteer appreciation) certificate with blank areas for information such
as names, hours, years of service, etc.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?bmVlc2llag==?=,

Yes, I do mail merge to create letters, but have not
used an Excel spreadsheet to merge/print information onto a preprinted
(volunteer appreciation) certificate with blank areas for information such
as names, hours, years of service, etc.

It's basically the same. You just insert the mergefields in the certificate
where you want the information from the Excel file to appear. Can you be more
specific as to what problems you're experiencing? Have you actually TRIED it?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail