Sub mTest()
Dim Base_XL$
Base_XL = "C:\Users\Staple1600\Documents\Tests\Base_Fuz.xlsx" '<-adapter chemin et nom fichier
ActiveDocument.MailMerge.OpenDataSource Name:=Base_XL, Connection:="Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};"
ActiveDocument.MailMerge.DataSource.ActiveRecord = wdLastRecord
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
End Sub