Adding signature

[dwarek]

Hello everyone i have a vba code to send email via outlook but the issue i don't know how to add signature to it, can signature can be predefined in the program or is it possible to extract signature from outlook using any command in vba code please help me out , below is my code , thanks in advance

Private Sub CommandButton1_Click()
Range("A2").Select
While Not ActiveCell = ""
Mail_To = ActiveCell.Offset(0, 0)
Mail_Subject = "testing"
Mail_Voting = ActiveCell.Offset(0, 4)
Set myolapp = CreateObject("Outlook.Application")
Set myitem = myolapp.CreateItem(olMailItem)


With myitem



.VotingOptions = Mail_Voting
.To = Mail_To

.Subject = ActiveCell.Offset(0, 1)
.body = ActiveCell.Offset(0, 2)


.display
End With

ActiveCell.Offset(1, 0).Select
Wend
End Sub


Private Sub CommandButton2_Click()
Unload UserForm2
End Sub

 

[mole999]

> Insert Outlook Signature in mail

 

[dwarek]

it is ok but the signature getting printed above the body how can make it print below the body?