Nhờ hỗ trợ em sửa mã VBA chèn chữ ký tự động khi gửi mail outlook

[leo.thy]

Em có đoạn mã như sau, em muốn khi bấm gửi thì các mail tự động chèn chữ ký vào, chữ ký e đã set sẵn trong outlook nhưng gửi hàng loạt như vậy thì chữ ký không tự chèn vào.

Sub Send_Files()
'Working in Excel 2000-2016
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
Dim OutApp As Object
Dim OutMail As Object
Dim sh As Worksheet
Dim cell As Range
Dim FileCell As Range
Dim rng As Range

With Application
.EnableEvents = False
.ScreenUpdating = False
End With

Set sh = Sheets("Sheet1")

Set OutApp = CreateObject("Outlook.Application")

For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)

'Enter the path/file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")

If cell.Value Like "?*@?*.?*" And _
Application.WorksheetFunction.CountA(rng) > 0 Then
Set OutMail = OutApp.CreateItem(0)

With OutMail
.to = cell.Value
.Subject = "phi ngay 07-04-2021"
.Body = "KINHGUIQUYDOITAC " & cell.Offset(0, -1).Value

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell

.Send 'Or use .Display
End With

Set OutMail = Nothing
End If
Next cell

Set OutApp = Nothing
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub

 

[befaint]

Dim Signature
Set OutMail = OutApp.CreateItem(0)

OutMail.Display
Signature = OutMail.body

With OutMail
.to = cell.Value
.Subject = "phi ngay 07-04-2021"
.Body = "KINHGUIQUYDOITAC " & cell.Offset(0, -1).Value & Signature
'......