• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mail Merge Document ..! group by and Save in one PDF format as per the Employee Name Like SMS Thread

Mohammad Shafaat

New Member
Hi team
Please help to any VBA code to save data Form as a PDF in one thread as per the EMP id Eg: Having 4 Accounts so Form showing in one PDF like Thread.
I m Using VBA code :
>>> use code - tags <<<
Code:
Sub Macro1()
'
' Macro1 Macro
'

'


Sheets("Retailer Dialogue-All retailers").Select
  Range("g5").Select
Dim r As Range
For i = 2 To Sheets("Sheet1").Range("e2")


  
   
    Sheets("Sheet1").Range("c" & i).Copy
   
   

    ActiveSheet.Paste
    Application.CutCopyMode = False

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Sheets("Sheet1").Range("c" & i), Quality:=xlQualityStandard, _
  IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False

Next
End Sub
It saves individually PDF in the folder Required Employee wise PDF with Grouping in one

Thanks In Advance..
 
Last edited by a moderator:
Top