Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I was wondering if anyone has experience with using Mailmerge or some other tool to take text form and Excel Spreadsheet and have it print on to a premade certificate. Sort of like an award certificate. So I have the paper that has the certificate image and border, I just need to take my data from excel and have it print onto the certificate and line up properly. Does anyone have any tips on how to best do this?
Why not create a Word Document and format it the way you want it to be? Excel is not really the right tool for this particular job.
Life's more painless for the brainless.
0 
The purpose of excel in this situation is all the data that will be merged with the pre-made certificate is in an .xls file. I was hoping there was some way I could format a mail merge doc that pulls the data into a word doc, have the data lined up to coincide with the certificate and then put the certificate paper in the printer and print them off.
0
I know how to do the merge of the data from excel to the word document, however how can I get the merge fields to line up with the pre-made certificate paper? I tried to scan the certificate and put it in a word document but the image size is all different. Sorry its sort of hard to explain the problem. Thanks for the responses so far!
0
I know this sounds crazy, but try this. Create your merge document in Word (with the fields you're using in the Excel spreadsheet). Run a merge and print out just one page. Then, compare the printed sheet to your certificate by putting it behinds a blank certificate sheet. I know it sounds kinda antiquated, but it works. Once you can see how the merged fields print, you'll know how to format the Word Document so that the certificates print just the way you want.
If the Certificates are pre-printed with Form numbers (Avery for example) that will make your job all the easier.
Life's more painless for the brainless.
0
Failing that, you can write a macro which pulls data from sheet 2 and puts it into sheet 1 (the certificate), printing out each sheet.
So on sheet 2 you would have the columns Name, Grade, Examiner. These would need to go into sheet 1 cells D5, D7, and D9 respectively.
Your macro would look something like this:
Sub certificate()
For irow 2 to 500
if len(sheet2.cells(irow, 1).value)>0 then
sheet1.cells(5, 4).formula = sheet2.cells(irow, 1).value
sheet1.cells(7, 4).formula = sheet2.cells(irow, 2).value
sheet1.cells(9, 4).formula = sheet2.cells(irow, 3).value
Sheet1.printout
End if
Next irowEnd sub
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
