How can I set up and export excel data to a certificate?

I am looking to set up up some sort of database that will alow me to enter
data in Excel on one page and automatically enter this into a certificate
which I can send out. I have seen this done before. but do not know how this
was done.

Can anyone help?

If I understand what you are looking for is something called a merge or more
commonly mail merge but you can actually use it with things other then
mailings such as certificates. It will require you to use both Word and
Excel or there are some other options. You can input your data that will be
inserted into the certs in Excel save the file as Cert data and then open
Word and create the "form" for the cert as far as insert this data here or
there using the insert form field options. Let me know if you need more help.

M

"Quita" wrote:

I am looking to set up up some sort of database that will alow me to enter
data in Excel on one page and automatically enter this into a certificate
which I can send out. I have seen this done before. but do not know how this
was done.

Can anyone help?

I wanted to be sure to put that they are actually called merge fields and
they are based on what the headings of the data you put in your data file are
called unless you create your data file in Word which you can also do.

"M" wrote:

If I understand what you are looking for is something called a merge or more
commonly mail merge but you can actually use it with things other then
mailings such as certificates. It will require you to use both Word and
Excel or there are some other options. You can input your data that will be
inserted into the certs in Excel save the file as Cert data and then open
Word and create the "form" for the cert as far as insert this data here or
there using the insert form field options. Let me know if you need more help.

M

"Quita" wrote:

I am looking to set up up some sort of database that will alow me to enter
data in Excel on one page and automatically enter this into a certificate
which I can send out. I have seen this done before. but do not know how this
was done.

Can anyone help?

Some links for MailMerge (excel holds the data and Word holds the
form/certificate):

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Quita wrote:

I am looking to set up up some sort of database that will alow me to enter
data in Excel on one page and automatically enter this into a certificate
which I can send out. I have seen this done before. but do not know how this
was done.

Can anyone help?

--

Dave Peterson