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

[Mohammad Shafaat]

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 <<<

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..

 

[Mohammad Shafaat]

Sample file i attached please help me on this and your valuable time