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 : docs.google.co...
Excel File used in Video : docs.google.co...
Best regards,
The Office Crew
By Sachin Tanwar
15 сен 2024