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”
.Send
End With
End With
End With
StopMacro:
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
ActiveWorkbook.EnvelopeVisible = False
End Sub
http://windowssecrets.com/forums/sh…
This one works for OUTLOOK only:
http://www.rondebruin.nl/win/s1/out…
MIKE
http://www.skeptic.com/
message edited by mmcconaghy