how do i use a database to print multiply certificates

[Guest]

im trying to print out certificates for trainees that have gained a
certificate, but i want to use the names and qualification gained that i have
in a data base. does anyone know how to incorperate the information ive got
into the certificates i want to print. If i can help it i dont want to have
to input everyones name and qualification onto each cert to print.

 

[Guest]

Are your certificates created by use of a report in your database? Or, are
these certificates purchased in pre-printed form on some type of paper? If
it is the former, it should be very easy to design a report that prints each
certificate with the appropriate name and certification.

If it is the latter, you'll need to design a custom report that prints the
values at the appropriate locations. This will take some trial and error to
get it right. Use blank paper to test the correct print locations, and hold
the printed results with a certificate up to a light to compare for correct
overlay position.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Another possible approach would be to use the Access data as a source for a
Word mail merge. This would enable you to use the formatting facilities of
Word. You could do it either through the Word user interface or from within
Access by means of automation. You'll find a demo of the latter, together
with other Access to Word operations at:

http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps

Ken Sheridan
Stafford, England

 

[westdr1dw]

When printing onto a preprinted form or certificate I have discovered
what works best for me is;

1. Save the document as an image.

2. Create a new Report in Access and insert the image.

3. Create a table of the recipeint names and other fields that will
appear on the certificate ie narrative,

This will also allow you to print subsequent certificate for the future
events.

If you have Publisher and Excel you can also do a mail merge. It is
pretty impressive to see a thousand certificates ready for print in
seconds.