certificate generator

[BruceFan]

Hi all,
I have seen youtube a video of a certificate generator but the website looks dodgy. "Make 1000 certificates for institute in one minute"

Can anyone help me with the basic code for this please? Or point me in the right direction of getting started?
I appreciate any help
Bruce

[Logit]

What is the URL of the website you viewed ? It would help to know some more specifics and hopefully the video would provide.

[BruceFan]

I'm not sure the links I'm using are posting.

So, what I want to do is have my students on sheet one with the subjects they have completed represented by the completion date and sheet 2 a certificate. I want to automatically generate a certificate for all students and show "Geography" completed 11/12/2019 or whatever subjects they have completed. Ideally they will automatically save as a PDF and email to the student!

[Logit]

.
Here is code to create and save the certificates. Student names are listed on the Students Sheet.

Please Login or Register  to view this content.

Here is a link to everything you'll need for creating an email via VBA : https://www.rondebruin.nl/win/s1/outlook/mail.htm

[BruceFan]

I'll give it a go. thank you very much

[BruceFan]

Hi!
I have had to eliminate these:

Please Login or Register  to view this content.

And it prints now.
My VBA skills are barely beginner, please advise what this is now not doing.
Many thanks

[Pepe Le Mokko]

@Brucefan

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[BruceFan]

Also;
I've messed around a little with it understandably, and now I have bugs at the beginnihng:

Please Login or Register  to view this content.

Why?! Thanks for all help

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[BruceFan]

All code fixed into boxes now, thanks.

I'd appreciate any help with getting this working.

[Logit]

Please attach your workbook.

[BruceFan]

The code is exactly as earlier in post, just showing where I have got a bug after making the changes mentioned.
Thank you for helping

[Logit]

The code works here. That is why I wanted to review your workbook.

Review your coding for spelling mistakes .... make certain the tab names are exactly the same as the names used in the code.

It is usually the simple stuff that gets ya.

[Pepe Le Mokko]

@Brucefan
Administrative note

Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks

[BruceFan]

Thanks for any help to get this project working.

[bakerman2]

As a starter.

Please Login or Register  to view this content.

[BruceFan]

Thank you for your help.
I'm getting the error of variable not defined and "sn" is being highlighted.
Are you able to please help me with that?

[bakerman2]

Put this on top of the code.

Please Login or Register  to view this content.

I never use Option Explicit so I hardly ever declare my variables.

[BruceFan]

I removed option explicit! My skills are so poor I don't know what it means anyway.

I have a bug on the line:

Please Login or Register  to view this content.

And i'm also told it has a print error. I actually don't want to print but rather save to PDF and email to students.

I have this code:

Please Login or Register  to view this content.

It obviously doesn't work! But I use a mac at home and office at work so looking for both codes and to save into a file called Certificates on the desktop.

[bakerman2]

This seems odd to me. Can you clarify.

Please Login or Register  to view this content.

[BruceFan]

That is me trying to save the file as persons name in K11.

[Logit]

Disregard.

[Logit]

.
The workbook functions with the elimination of TABLES.

The attached is the basic workbook. Note that all TABLES have been removed.

Please Login or Register  to view this content.

[BruceFan]

Thank you. I will give it a run.
If we want to email the PDF instead of printing it from an email listed beside each students name, how do we do this please?
Thank you so much for your help so far.

[Logit]

Please Login or Register  to view this content.