How to Mail Merge Certificates - Office 365 - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Sanju
Question:-
ABCD college is issuing certificates to 5 students who secured first, second and third -
positions in the college in the three courses- B.A(P), B.Sc(H), and B.Com(H). The data record-
(Student.xls) has the following fields: Name, Roll No, Course, and Position. Write steps to -
register the data source and issue the individual certificates using mail merge. The format of -
the letter is as follows:-
ABCD College-
Date: 21/11/2021-
This is to certify that Mr./Ms. has secured in ABCD-
College.-
Principal-
ABCD College
Plz make a video
reply
Question:-
ABCD college is issuing certificates to 5 students who secured first, second and third -
positions in the college in the three courses- B.A(P), B.Sc(H), and B.Com(H). The data record-
(Student.xls) has the following fields: Name, Roll No, Course, and Position. Write steps to -
register the data source and issue the individual certificates using mail merge. The format of -
the letter is as follows:-
ABCD College-
Date: 21/11/2021-
This is to certify that Mr./Ms. has secured in ABCD-
College.-
Principal-
ABCD College
Plz make a video
reply
xxes11xx
Could you do one like this for PPT + Excel? I've only seen very crazy cases with coding to be done by the user, and that terrifies me.... I've created a beuatiful PPT certificate, now I want to make my life easier when inputting the names. Thank you very much!
reply
Could you do one like this for PPT + Excel? I've only seen very crazy cases with coding to be done by the user, and that terrifies me.... I've created a beuatiful PPT certificate, now I want to make my life easier when inputting the names. Thank you very much!
reply
sciphan
Hey man, your videos have been super helpful, but I have a question. Is there a way to do the Mail Merge function on a certificate that has a form field for the name but the rest of the document is edit-protected?
reply
Hey man, your videos have been super helpful, but I have a question. Is there a way to do the Mail Merge function on a certificate that has a form field for the name but the rest of the document is edit-protected?
reply
Rye
Hi Kevin! This is so great! Assuming my data source includes their email addresses. Is there an option to automate to send the generated certificates to their respective email addresses?
reply
Hi Kevin! This is so great! Assuming my data source includes their email addresses. Is there an option to automate to send the generated certificates to their respective email addresses?
reply
Zafar
Dear Kevin, Thanks a lot for this and lot of other tutorials you share, I just want to know if there is a way, we can email these Certificates to recipients as PDF in the attachment?
reply
Dear Kevin, Thanks a lot for this and lot of other tutorials you share, I just want to know if there is a way, we can email these Certificates to recipients as PDF in the attachment?
reply
Sandy
If I have a pdf certificate how do I get that file in word to start merge? 4 fields First name, last name, date, year? How does Microsoft word know where to place the four fields?
reply
If I have a pdf certificate how do I get that file in word to start merge? 4 fields First name, last name, date, year? How does Microsoft word know where to place the four fields?
reply
MrJBalisong
hi bro i saw your tutorial ... i was wondering could you teach me how to do it on 2 page per sheet on page set up when i save it goes blank on the page in pdf
reply
hi bro i saw your tutorial ... i was wondering could you teach me how to do it on 2 page per sheet on page set up when i save it goes blank on the page in pdf
reply
Simone
Thank you Kevin.
I found this very helpful. Is there a way that the certificates could be converted to pdf when emailed as an attachment by mail merge?
reply
Thank you Kevin.
I found this very helpful. Is there a way that the certificates could be converted to pdf when emailed as an attachment by mail merge?
reply
Gilbert
Hi Kevin, can I make a request< Can you upload a tutorial on how to use autocrat? Thank you and looking forward for your favorable response. God Bless
reply
Hi Kevin, can I make a request< Can you upload a tutorial on how to use autocrat? Thank you and looking forward for your favorable response. God Bless
reply
easyspeaking2u
-KevinStratvert How can I do the mail merge for the certificates then send the individual certificates to the persons email...HELP
reply
-KevinStratvert How can I do the mail merge for the certificates then send the individual certificates to the persons email...HELP
reply
Add a review, comment
Other channel videos
