Solved Add default signature to excel macro

October 24, 2015 at 08:39:06
Specs: Windows 7
I was hoping that someone can help me add my default signature to this macro in excel. I am not a programmer so I am asking that if you so kindly help me that you can modify the macro below to add the signature functionality. I was able to make the below macro work by searching the internet, not through no skills of my own :-( but could not figure out the signature part.

Sub Z5_Email4()
Dim Sendrng As Range

On Error GoTo StopMacro

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

Set Sendrng = Selection

'Create the mail and send it
With Sendrng

ActiveWorkbook.EnvelopeVisible = True
With .Parent.MailEnvelope

.Introduction = "Z leads to call/disposition TODAY"

With .Item
.To = "TESTgroup"
.Subject = "Z5 Test"
.Body = "Z5 List to call please"
End With

End With
End With

With Application
.ScreenUpdating = True
.EnableEvents = True
End With
ActiveWorkbook.EnvelopeVisible = False

End Sub

See More: Add default signature to excel macro

Report •

October 24, 2015 at 20:09:35
✔ Best Answer
Found these two sites, see if they do what you need:

This one works for OUTLOOK only:


message edited by mmcconaghy

Report •
Related Solutions

Ask Question