Create Individual Increment PDF from Mail Merge | How to Mail Merge in MS Word in Hindi | Excel link
ฝัง
- เผยแพร่เมื่อ 11 ก.ค. 2024
- #Excel #Mailmerge #IPTMNoida
In this video, you learn how to Create Individual Increment PDF from Mail Merge and How to Mail Merge in MS Word in Hindi from Excel link.
Learn Easy How To guide on how to automatically separate and name your PDF files from word without any software.
Buy Me a Coffee? Your support is much appreciated!
---------------------------------------------------------------------------------------
PayPal me: www.paypal.com/paypalme/ajity...
CC/DC/Net-banking/Wallet/UPI/Paytm: pmny.in/pIubju7D8FVh
Click to get this code (Do not send Email): 99excel.com/mail-merge/
Mail Merge is a really useful feature built-in in Microsoft Word to create letters, labels, envelopes, or even drafting email in bulk. But not everything is perfect. One of the drawbacks with mail merge is that when you try to print each record as a single PDF file, unfortunately, Word combined all the records in one single PDF. Also, you cannot perform mail merge to save each record as their own individual Word document. By writing some VBA code, we can easily overcome the obstacle.
⌚ Timestamps
00:00 Inro
00:02 Work Reference
02:50 Mail Merging steps
08:36 VBA Code for PDF
🔔 Channel Subscribe जरूर करे : th-cam.com/users/IptmOrgInak...
_____________________________________________________
☑️Payroll Training Course by IPTM: www.iptm.org.in
☑️New Batch Enquiry: bit.ly/training-enquiry
Payroll Blog: www.payrollpedia.org/
Excel Blog: 99excel.com/home/
Excel Tools: 99excel.com
_____________________________________________________
EQUIPMENT’S & SERVICES I USE:
Laptop: amzn.to/3bE0JDD
Webcam: amzn.to/2LqRkVl
Microphone (Boya): amzn.to/2LtEMMW
4K Ultra HD Smart LED TV: amzn.to/3ssTNPD
Chromakey Green Scree: amzn.to/3sAMbL9
I RECOMMEND:
Start Own Busines Online: amzn.to/39AEOua
Get Amazon Prime: amzn.to/2LU0bPe
Best Hosting (hostgator): bit.ly/3oJDzPD
Find People and Services: fwd.cx/NVOg9i3VfkSS
CREATED BY:
Ajit Kumar Yadav (AKumar)
Follow Me on Instagram: / akumar0808
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thanks for coming over here.
#iptmnoida #99Excel
#MailMerge
#MailMergeExcel
#EasyExplain
#MailMergeinHindi
#VBA
#ExcelVBA
Efficient.. totally awesome 👍
JazakAllah Khair Bhai
VERY HELPFULL
Thanhs very much
thank you
Superb. It helped a lot to prepare 1 page letters. Plz advise how to use this if there are two or more pages in each letter.
Excellent boss
Thanks
Really helpful for Bulk creation plz provide macro code Thank U Sir
thanks for your support, I'm getting an erro in ActiveDocument.MailMerge.DataSource.ActiveRecord = From , can you pls help me how to solve it
When we are selecting excel sheet for mailmerge it's also taking 9-10 decimal points of amounts in word doc..how do we limit it to 2 decimal points?
Sir, it shows error as “Runtime error ‘5941’ th e requested member of collection does not exist” please help
while running the code one i page is saving , we need all page should be save
If there is 2page for 1pdf so what will b the code
Nice video can you please share the VBA code
Nice Informative Video, very helpful, plz share the VBA Code
Please share the VBA code
My pdf report has Y.tube by cliped, how can I get that from clip.
Sir, i have send an mail to get developing code. But didn't received it.. So please send me asap🙏🏻.. Thanks in advanced
Please let me know how to prepare 2 page letters
Nice video sir can you please share the vba code
Can u send those pdf's individually to the respective email address using mail merge at once
How can we send these generated pdf individually on their email.
My question same to write below.
its realy helpful ,plz share me above code
Dear Sir, I used your generated code but it gives me this error "ActiveDocument.MailMerge.DataSource.ActiveRecord = From" what I have to do
How to create with 2 page pdf mail merged
Hi sir hiw to write my path in vba
it error on line
DocName = ActiveDocument.Fields(1).Result
sir what is version of word because i couldn't see the Developer option please suggest
Goto file, customize ribbon, tick right side
Sir request to please share code for 2 pages
Developer option kaha hota h sir??
developer tool not shown
ERROR SHOW RUNTIME ERROR OBJECT REQUIRED PLEASE SOLVE THE PROBLEM
i need this code please
Sir mujh ko ye vba code chahiye pls
Ise Send Kaise Kare Email Par??
Very helpful.. nice video. can you please send me the code
Check video description link
Is there any way to combined all pdf into single pdf also ....
That is easy just get print out of all word files it will automatically convert them into PDF
Please send this code for septet file as name pku.deoria@gmail.com
Hi, can you share the full code for page 2?
Email us
@@Indianpayroll please share full code page 2
Developers lane ke liye code to batao
Hi
what if we have more than 1 page in increment letter?
Range:=wdExportFromTo, From:=1, To:=2
Put no. of pages in to
@@sayaligawade7782 Thanks it worked
Please share code
Error : Object Is not available
How to save pdf if the letter contain 3 pages ??
Range:=wdExportFromTo, From:=1, To:=2
Put no. of pages in to
@@sayaligawade7782 where to add this range
@@manurajrajan5591 Its solve or not if solve please share where to add
I am not able to get the second page
Range:=wdExportFromTo, From:=1, To:=2
Put no. of pages in to
@@sayaligawade7782 Please share whole code. Appreciate your prompt response, need to fix it
@@sayaligawade7782 I tried this, it is throwing error
@@riteshkhirodkar8604 can you me on this plz
@@rvreddy4855 share ur code
Sir, how to get 2 page?
Range:=wdExportFromTo, From:=1, To:=2
Put no. of pages in to
@@sayaligawade7782 not working 2 page code please help how to rune 2 page code
@@badboygaming3311 send ur code here
@@sayaligawade7782 i got the problem
@@sayaligawade7782 bro i need small help i want change save name please help
Mil skta hai kya
Dear Sir, I used your generated code but it gives me this error "Run-time error'-2147467259(80004005)': The export failed bocause this feature is not instaled." what I have to do sir please help me.
Mail merge not done correctly
Sir mughe code chahiye
Anyone help me
🤔vielen Dank für die Bereitstellung der VBA-Codierung in der Beschreibung des Videos Ihres Kanals. Es wird mir definitiv helfen, viel Zeit zu sparen
🤔आपके चैनल के वीडियो के विवरण में VBA कोडिंग प्रदान करने के लिए धन्यवाद। यह निश्चित रूप से मुझे बहुत समय बचाने में मदद करेगा
🤔Спасибо, что указали кодировку VBA в описании видео вашего канала. Это определенно поможет мне сэкономить много времени
채널의 동영상 설명에 VBA 인코딩을 포함시켜 주셔서 감사합니다. 이것은 확실히 많은 시간을 절약하는 데 도움이 될 것입니다.
اپنے چینل کی ویڈیو کی تفصیل میں VBA انکوڈنگ شامل کرنے کا شکریہ۔ یہ یقینی طور پر آپ کو کافی وقت بچانے میں مدد دے گا۔
Thanks
JazakAllah Khair Bhai