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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

neesiej - 13 May 2005 09:48 GMT

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

Reply to this Message

Cindy M -WordMVP- - 20 May 2005 14:09 GMT

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 :-)

Reply to this Message

neesiej - 22 May 2005 00:30 GMT

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.

> Hi =?Utf-8?B?bmVlc2llag==?=,
>
[quoted text clipped - 15 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 22 May 2005 08:40 GMT

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 :-)

Reply to this Message