Create Individual Increment PDF from Mail Merge | How to Mail Merge in MS Word in Hindi | Excel link

Поделиться
HTML-код
  • Опубликовано: 15 июл 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 जरूर करे : ruclips.net/user/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

Комментарии • 84

  • @sorabhkumarsharma
    @sorabhkumarsharma 2 года назад +1

    Efficient.. totally awesome 👍

  • @winner1x
    @winner1x 4 месяца назад +1

    VERY HELPFULL

  • @anjumphotos2338
    @anjumphotos2338 3 месяца назад

    JazakAllah Khair Bhai

  • @kalpanaroy3429
    @kalpanaroy3429 Год назад

    Thanhs very much

  • @user-hz8mh1vr1p
    @user-hz8mh1vr1p 11 месяцев назад

    thank you

  • @rvreddy4855
    @rvreddy4855 2 года назад +1

    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.

  • @harshadbarot
    @harshadbarot 2 года назад +1

    Excellent boss

  • @SMITHSALUNKE
    @SMITHSALUNKE 3 года назад

    Really helpful for Bulk creation plz provide macro code Thank U Sir

  • @mahendragupta404
    @mahendragupta404 3 года назад

    Nice Informative Video, very helpful, plz share the VBA Code

  • @rikitajoshi4
    @rikitajoshi4 2 года назад

    Nice video can you please share the VBA code

  • @mjhtmayurnish
    @mjhtmayurnish Год назад

    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?

  • @ShivAutoz
    @ShivAutoz Год назад

    thanks for your support, I'm getting an erro in ActiveDocument.MailMerge.DataSource.ActiveRecord = From , can you pls help me how to solve it

  • @kalpanaroy3429
    @kalpanaroy3429 Год назад

    My question same to write below.

  • @pradeepbeherag.3418
    @pradeepbeherag.3418 Год назад

    Nice video sir can you please share the vba code

  • @naresh90sharma
    @naresh90sharma Месяц назад

    while running the code one i page is saving , we need all page should be save

  • @pratimayadav1089
    @pratimayadav1089 2 года назад

    Sir, it shows error as “Runtime error ‘5941’ th e requested member of collection does not exist” please help

  • @manurajrajan5591
    @manurajrajan5591 2 года назад

    If there is 2page for 1pdf so what will b the code

  • @pkmeena6390
    @pkmeena6390 9 месяцев назад

    its realy helpful ,plz share me above code

  • @SuperJackyyyy
    @SuperJackyyyy 3 года назад +1

    Can u send those pdf's individually to the respective email address using mail merge at once

    • @areyaar8236
      @areyaar8236 2 года назад

      How can we send these generated pdf individually on their email.

  • @DeadbeatGaming1705
    @DeadbeatGaming1705 Год назад

    Please let me know how to prepare 2 page letters

  • @MithleshKumar-sd2ft
    @MithleshKumar-sd2ft Год назад

    Hi

  • @kalpanaroy3429
    @kalpanaroy3429 Год назад

    My pdf report has Y.tube by cliped, how can I get that from clip.

  • @trishulhelpdesk9289
    @trishulhelpdesk9289 2 года назад

    Sir, i have send an mail to get developing code. But didn't received it.. So please send me asap🙏🏻.. Thanks in advanced

  • @kishorkumar-lf6ow
    @kishorkumar-lf6ow 2 года назад +1

    Very helpful.. nice video. can you please send me the code

  • @puttaponparksuwan2385
    @puttaponparksuwan2385 11 месяцев назад

    it error on line
    DocName = ActiveDocument.Fields(1).Result

  • @SunilKumar-zg7fm
    @SunilKumar-zg7fm 3 года назад

    sir what is version of word because i couldn't see the Developer option please suggest

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      Goto file, customize ribbon, tick right side

  • @rajeshbisht7743
    @rajeshbisht7743 2 года назад

    Sir request to please share code for 2 pages

  • @homeresending2606
    @homeresending2606 2 года назад

    Dear Sir, I used your generated code but it gives me this error "ActiveDocument.MailMerge.DataSource.ActiveRecord = From" what I have to do

    • @kingsm1382
      @kingsm1382 Год назад

      How to create with 2 page pdf mail merged

  • @sarikalidhuwarjunghazipur6871
    @sarikalidhuwarjunghazipur6871 3 месяца назад

    Ise Send Kaise Kare Email Par??

  • @sajeethahamed6144
    @sajeethahamed6144 Год назад

    Hi sir hiw to write my path in vba

  • @NirajKumar-yl4pb
    @NirajKumar-yl4pb 2 года назад

    Developer option kaha hota h sir??

  • @javedali230
    @javedali230 Год назад

    Sir mujh ko ye vba code chahiye pls

  • @deepakfialok
    @deepakfialok 3 года назад

    Is there any way to combined all pdf into single pdf also ....

    • @syedarshadmushtaq6315
      @syedarshadmushtaq6315 3 года назад

      That is easy just get print out of all word files it will automatically convert them into PDF

    • @pramodupadhyay120
      @pramodupadhyay120 3 года назад

      Please send this code for septet file as name pku.deoria@gmail.com

  • @apexsummitsecretariat3044
    @apexsummitsecretariat3044 3 года назад

    developer tool not shown

  • @niconiconi5801
    @niconiconi5801 2 года назад +1

    Hi, can you share the full code for page 2?

  • @susendeshmukh892
    @susendeshmukh892 Год назад

    i need this code please

  • @rajeshsaxena2032
    @rajeshsaxena2032 Год назад

    ERROR SHOW RUNTIME ERROR OBJECT REQUIRED PLEASE SOLVE THE PROBLEM

  • @jhanvigandhi5949
    @jhanvigandhi5949 3 года назад

    Developers lane ke liye code to batao

  • @livingwithtrend
    @livingwithtrend 3 года назад

    what if we have more than 1 page in increment letter?

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      Range:=wdExportFromTo, From:=1, To:=2
      Put no. of pages in to

    • @vikrantjadhav2326
      @vikrantjadhav2326 2 года назад +1

      @@sayaligawade7782 Thanks it worked

  • @MuzaffarpurBoy
    @MuzaffarpurBoy 3 года назад

    Please share code

  • @tiwarivikash8310
    @tiwarivikash8310 2 года назад

    Error : Object Is not available

  • @SunilYadav-hr9zg
    @SunilYadav-hr9zg 2 года назад

    How to save pdf if the letter contain 3 pages ??

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      Range:=wdExportFromTo, From:=1, To:=2
      Put no. of pages in to

    • @manurajrajan5591
      @manurajrajan5591 2 года назад

      @@sayaligawade7782 where to add this range

    • @rajeshbisht7743
      @rajeshbisht7743 2 года назад

      @@manurajrajan5591 Its solve or not if solve please share where to add

  • @ricoani
    @ricoani 3 года назад

    I am not able to get the second page

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      Range:=wdExportFromTo, From:=1, To:=2
      Put no. of pages in to

    • @riteshkhirodkar8604
      @riteshkhirodkar8604 2 года назад

      @@sayaligawade7782 Please share whole code. Appreciate your prompt response, need to fix it

    • @rvreddy4855
      @rvreddy4855 2 года назад

      @@sayaligawade7782 I tried this, it is throwing error

    • @rvreddy4855
      @rvreddy4855 2 года назад

      @@riteshkhirodkar8604 can you me on this plz

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      @@rvreddy4855 share ur code

  • @swatisid1
    @swatisid1 3 года назад

    Sir, how to get 2 page?

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      Range:=wdExportFromTo, From:=1, To:=2
      Put no. of pages in to

    • @badboygaming3311
      @badboygaming3311 2 года назад

      @@sayaligawade7782 not working 2 page code please help how to rune 2 page code

    • @sayaligawade7782
      @sayaligawade7782 2 года назад

      @@badboygaming3311 send ur code here

    • @badboygaming3311
      @badboygaming3311 2 года назад

      @@sayaligawade7782 i got the problem

    • @badboygaming3311
      @badboygaming3311 2 года назад

      @@sayaligawade7782 bro i need small help i want change save name please help

  • @pradeepbeherag.3418
    @pradeepbeherag.3418 2 года назад

    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.

  • @surajkumarsingh2627
    @surajkumarsingh2627 11 месяцев назад

    Mil skta hai kya

  • @surajkumarsingh2627
    @surajkumarsingh2627 11 месяцев назад

    Anyone help me

  • @surajkumarsingh2627
    @surajkumarsingh2627 11 месяцев назад

    Sir mughe code chahiye

  • @user-jt4en2po1o
    @user-jt4en2po1o 2 года назад +1

    🤔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 انکوڈنگ شامل کرنے کا شکریہ۔ یہ یقینی طور پر آپ کو کافی وقت بچانے میں مدد دے گا۔

  • @zkstipstricks2893
    @zkstipstricks2893 3 года назад

    JazakAllah Khair Bhai