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 \ud83d\ude41 but could not figure out the signature part.<\/p>\n
Sub Z5_Email4()
\nDim Sendrng As Range<\/p>\n
On Error GoTo StopMacro<\/p>\n
With Application
\n.ScreenUpdating = False
\n.EnableEvents = False
\nEnd With<\/p>\n
Set Sendrng = Selection<\/p>\n
‘Create the mail and send it
\nWith Sendrng<\/p>\n
ActiveWorkbook.EnvelopeVisible = True
\nWith .Parent.MailEnvelope<\/p>\n
.Introduction = “Z leads to call\/disposition TODAY”<\/p>\n
With .Item
\n.To = “TESTgroup”
\n.Subject = “Z5 Test”
\n.Body = “Z5 List to call please”
\n.Send
\nEnd With<\/p>\n
End With
\nEnd With<\/p>\n
StopMacro:
\nWith Application
\n.ScreenUpdating = True
\n.EnableEvents = True
\nEnd With
\nActiveWorkbook.EnvelopeVisible = False<\/p>\n
End Sub<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":2},"question-category":[53],"question_tags":[],"class_list":["post-14025","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/14025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=14025"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=14025"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=14025"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=14025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}