This is, by far one of the most useful tutorials I've ever found over the internet, not complex languaje, step by step instructions, code included !!! Congratulations, thanks for sharing your knowledge, greettings from Guatemala, Central America👏👏
Thank you for sharing this video. It's soooooo super duper helpful. I have successfully created 573 certificates in a day, different names, seperate files in Microsoft Word and PDF format using the technique and code given in this video. Thank you so much! For those who are trying it, it actually worked. If stuck with the code, just choose end and select click recipients again. Uncheck the ones in the list that you have done. Then go to Developer, Macros and click "Run" again All the best
Thanks for sharing this video. Any idea how to correct the error that I received? It shows: Run-time error '5941': The requested member of the collection does not exist. Info below highlighted in yellow: singleDoc.SaveAs2 _ FileName:=masterDoc.MailMerge.DataSource.DataFields("DocFolderPath").Value & Application.PathSeparator & _ masterDoc.MailMerge.DataSource.DataFields("DocFileName").Value & ".docx", _ FileFormat:=wdFormatXMLDocument ' Save "singleDoc" as a word docx with the details provided in the DocFolderPath and DocFileName fields in the MailMerge data singleDoc.ExportAsFixedFormat _
My code stuck while creating saving Docs and PDFs. created file has only text "Word found locked fields during the update. Word can't update locked fields."
This is, by far one of the most useful tutorials I've ever found over the internet, not complex languaje, step by step instructions, code included !!! Congratulations, thanks for sharing your knowledge, greettings from Guatemala, Central America👏👏
Thank you for sharing this video. It's soooooo super duper helpful. I have successfully created 573 certificates in a day, different names, seperate files in Microsoft Word and PDF format using the technique and code given in this video. Thank you so much!
For those who are trying it, it actually worked. If stuck with the code, just choose end and select click recipients again.
Uncheck the ones in the list that you have done. Then go to Developer, Macros and click "Run" again
All the best
Sir, ang galing nyo pong mg instruct at provided pa yung code. Astig!
This definitely saved me at work today! Thank you!
It is working (Windows - July 7th, 22). Thank you so much!
*AMAZING TUTORIAL*
Brother YOU made my life sooooo much easier with this. THANK YOU!!!!
this was awesome! thanks for sharing!
شكرا على الشرح، لقد ساعدني كثيرا 🥰🥰
Thank you, it worked :)
Thank you Bro, it's really great
fantastic
Thanks for sharing this video. Any idea how to correct the error that I received? It shows:
Run-time error '5941':
The requested member of the collection does not exist.
Info below highlighted in yellow:
singleDoc.SaveAs2 _
FileName:=masterDoc.MailMerge.DataSource.DataFields("DocFolderPath").Value & Application.PathSeparator & _
masterDoc.MailMerge.DataSource.DataFields("DocFileName").Value & ".docx", _
FileFormat:=wdFormatXMLDocument ' Save "singleDoc" as a word docx with the details provided in the DocFolderPath and DocFileName fields in the MailMerge data
singleDoc.ExportAsFixedFormat _
I am stuck in getting the codes, may I know how to get them? I am using my macbook.
My code stuck while creating saving Docs and PDFs. created file has only text "Word found locked fields during the update. Word can't update locked fields."
Thanks for cooperation, but can't open out file details.
how to share those PDF files with the respective individuals in a single stretch?
where can i find the code to be pasted on module1?
Can you help me open the file?pl.
What to do if syntax error arrived ?
you are amazing
Hi, somehow it does not work for me, only generated one doc. for first line , then 'run time error 5941 appears'. Any help?
I got this same error as I hadn't added the 'PDfFilePath' and 'PDfFileName' columns on the excel. Once I added them it worked like a charm!
@@tz2212 thanks for the reply, but i did have those named columns in the excel
How do I get this vba macro code?
docs.google.com/document/d/17VvgfO_xW2kFQIjS0Tqacn1rJ4Phzq1oz-G5CYCCh1s/edit?usp=sharing
Paano po nakuha iyong codes?
docs.google.com/document/d/17VvgfO_xW2kFQIjS0Tqacn1rJ4Phzq1oz-G5CYCCh1s/edit?usp=sharing
Kinda plagiarised the Imnoss's code though... at least share the credit.
Sir give code
docs.google.com/document/d/17VvgfO_xW2kFQIjS0Tqacn1rJ4Phzq1oz-G5CYCCh1s/edit?usp=sharing
Ok. Thanks.
@@seosamhsensei2008thanks.
@@seosamhsensei2008 thanks.
Pl.help to open out the file.
SHOWING ERROR CODE 5852. plz help