how can i print hundreds of records one by one from excelsheet

[programming]

i want to know that i am having 800 records of my students, i want to print
certificate for my students, so that i need that the name ,address, date of
test should be print at the back side of the certificate. give me some ideas
to do this work or if your have any type of macros to solve this problem you
can send it to me. thanks for listenning this

 

[Dave Peterson]

Lots of times, it's easier to use MSWord for printing and Excel (or some other
database application) as the source.

You may want to read some tips for mailmerge.
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.

And if you notice problems with the formatting of data (like zipcodes)...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

======================
But if you want to use only excel, maybe something like this from Debra
Dalgleish's site:
http://contextures.com/xlForm03.html

 

[Joel]

You can find free certificates at the following microsoft website

http://office.microsoft.com/en-us/templates/CT101043001033.aspx

You can embed a word document into an Excel worksheet and then activate the
document with a macro. The macro can add one at a time each student and
print the document.

 

[Joel]

You could probably do it either as a macro in excel and open a word document
or do the macro in word and open excel to get the names to put on the
certificates.