MAIL MERGE PART2: Create Individual Document/ PDF File with Customized Filename Using Mail Merge
HTML-код
- Опубликовано: 11 сен 2024
- Create Individual Document/ PDF File with Customized Filename Using Mail Merge
Thanks to SIMNOSS
VBA Code Link: docs.google.co...
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!
*AMAZING TUTORIAL*
Brother YOU made my life sooooo much easier with this. THANK YOU!!!!
It is working (Windows - July 7th, 22). Thank you so much!
شكرا على الشرح، لقد ساعدني كثيرا 🥰🥰
this was awesome! thanks for sharing!
Thank you Bro, it's really great
fantastic
Thank you, it worked :)
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."
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
where can i find the code to be pasted on module1?
how to share those PDF files with the respective individuals in a single stretch?
I am stuck in getting the codes, may I know how to get them? I am using my macbook.
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 _
you are amazing
What to do if syntax error arrived ?
Thanks for cooperation, but can't open out file details.
Can you help me open the file?pl.
Kinda plagiarised the Imnoss's code though... at least share the credit.
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
SHOWING ERROR CODE 5852. plz help
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.