♫musicjinni

Mail Merge : Make Certificates in Bulk Quickly | Fast PDF Automatic Certificates | Save Time

video thumbnail
Generate Bulk Certificate Quickly | 1000+ Certificates in few Minutes | Mail Merge + Excel + PDF

Create PDF certificates/ Digital Certificates We all can save our a lot of time by using the Mail Merge. In this video we will learn how to create certificates in bulk for n number of students/participants.

We are going to use Mail Merge for bulk emails, letters, labels, envelopes and certificates. Mail merge lets us create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document. Placeholders--called merge fields--tell Word where in the document to include information from the data source.
The work on the main document in Word, inserting merge fields for the personalized content you want to include. When the mail merge is complete, the merge document will generate a personalized version of itself for each name in the data source.

Certificate used in Video : https://docs.google.com/document/d/1nXBtB70b1yfHyhF-SMLk7wUR0UIk-Y0O/edit?usp=sharing&ouid=110202133162477170720&rtpof=true&sd=true

Excel File used in Video : https://docs.google.com/spreadsheets/d/1ZtfwYMJwh_0HgqUjx5dyhuC0FiJMQDPT/edit?usp=sharing&ouid=110202133162477170720&rtpof=true&sd=true

Best regards,
The Office Crew
By Sachin Tanwar

Create certificate in ms word and use mailings.

Disclaimer DMCA