Outlook signature is added in a message created in Excel




About this tutorial:

Video duration: 2:51
Add a signature to an outlook message created in Excel
include Outlook signature in a message created in Excel. insert outlook signature.

Code
Sub sendsignit()

Dim OApp As Object, emailMail As Object, signature As String
Dim eddress As String
Dim subj As String
Dim message As String

Set OApp = CreateObject(“Outlook.Application”)
Set emailMail = OApp.CreateItem(0)
edress = Sheet1.Cells(2, 1)
subj = Sheet1.Cells(2, 2)

With emailMail
.display
End With
signature = emailMail.body
With emailMail
.To = edress
.Subject = subj
‘.Attachments.Add
.body =…

Incoming search terms:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads