Print attandance certificates from a given name list

[wayneg]

Hi all, and thanks again for a wonderful forum, it really helps me get through my sticky situation.. i am learning more and more as i progress.

my question for this month is....

i have a list of names and want to print an attendence certificate off for each individual on that list. is there a way of doing this automatically or is it copy/paste.. print.. then do next one.

thanks in advance

wayne

[wenqq3]

Is possible with macro, can you attach a sample workbook. Thanks

[wayneg]

this is quick mock up of it.. obviously it wont be like this

[wenqq3]

Please Login or Register  to view this content.

Please set your print area probably. And test with 2 name 1st, before you proceed the all.

[wayneg]

thanks, yh... that worked ok. just need to make an official one now.


thanks for your prompt answer

[wenqq3]

Welcome Great it help!