Printing - large certificate printing project?

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
Jack og UK - is there code to put a text boxt on a sheet and put names from another list?
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
You might try a mail merge using word and your data in excel...printing on your already printed background.

pll
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215

ADVERTISEMENT

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
 

white6174

Board Regular
Joined
May 6, 2002
Messages
137
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
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
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.
 

Forum statistics

Threads
1,144,050
Messages
5,722,229
Members
422,417
Latest member
Johhny

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
Top