Generate certificate using mail merge

[mso3]

Hi friends,

I want to create a certificate using mail merge.
There are register numbers in column ‘A’.
I want to generate a certificate using mail merge as per the requirement of user.

Please suggest me a vba code to achieve the target quickly.

I want to store the output of certificate in an ‘output’ folder.

Any help will be highly appreciated.

Thanking you in anticipation.

[mso3]

Bump!

Any assistance please!
The code in attached file is for birthday which is working fine. Now I want to amend it to generate certificates for register number.

Please see the code and suggest me an amendment to achieve my target positively.

Any help will be highly appreciated.

Thanking you in anticipation.