Printing - large certificate printing project?

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,786
Office Version
  1. 2016
Platform
  1. Windows
Need to print 950 certificates.

I tried to set the picture as back ground but it will not print. All I can figure to do is put the picture on sheet 1 and then may VBA code names to a text box and put that on the picture?????

1. Certificate name is picture.jpg
a. Sized = 8 x 10.
b. Picture will be on Sheet 1.
c. Names for certs will be on Sheet 2, probably in column A.

2. Text box criteria:
a. font size = 26
b. font = CG Times
c. lines = none
d. fill = none
e. text box probably needs to be centered at about G22.

3. Picture takes up from column A1 to O44.
This message was edited by em on 2002-10-18 09:40
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Hi Em

Backgrounds do not print

All suggest is print the certificate printing project PICTURE / BACKGROUND Only first like headed paper if you like then print on top the licence or certifiate

HTH

Jack
 
Upvote 0
Jack og UK - is there code to put a text boxt on a sheet and put names from another list?
 
Upvote 0
You might try a mail merge using word and your data in excel...printing on your already printed background.

pll
 
Upvote 0
Hi Em

No thats not what i ment i tried to help and make it a two step process like headed paper, and the latter poster concures.

This willbe the best option i feel and save all teh agro.

Images in Excel are not good if text to go over them, Excel dont watermark very well i feel

Jack
 
Upvote 0
How about instead of a text box, have a linked picture or any shape you want that references to the cell on the other sheet.

Insert your picture on the sheet

now instead of a textbox use a Rectangle

select the Rectangle and in the formula bar input the cell on the other sheet with the data you want (just like a linked cell)

hope this helps
steve w
 
Upvote 0
Hi white6174

Love the ideas but doubt this will work as a background and the original question requests, but like i say like it!!

Worth remembering that point thanks

Jack
 
Upvote 0
On 2002-09-29 14:20, em wrote:
Need to print 950 certificates.

If you are using fancy stock, or you would like to use fancy stock, why not shop this project around, see what the local printers (photocopy and traditional) can offer you.

You have almost 1000 copies; an economy of scale which should satisfy both parties concerned.

Just find one that has been there, done that. Supply a data file to their liking, and let them worry about the details.

I assume these 950 certificates are part of some business/non-profit model. Probably you are doing somebody a favor. Meet them halfway: you find a suitable vendor, do the liason, and let your 'boss' of your efforts pay the vendor.
 
Upvote 0

Forum statistics

Threads
1,218,691
Messages
6,143,941
Members
450,516
Latest member
shironokuro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top