Excel VBA E-mail Signature Question.

[Richard1982]

Hello!
I've just joined the forum so I'm new, although I've been using Excel at work for a while now - I'm slowly getting to grips with it. I produce a daily report that gets e-mailed out (directly from Excel) to many people. At the moment it creates the e-mails but I have to manually click on the Outlook window it produces to add my signature, is there anyway to automate adding the signature? If it could add the signature then I'd skip the bit where it shows the e-mails and it would just send them, so it would save me a fair bit of time.

The code for sending the e-mails is:

Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
EmailName = WorksheetFunction.VLookup(pf.PivotItems(i).Name, Worksheets("Email").Range("DivHeadTable"), 2)
.Display

.To = WorksheetFunction.VLookup(pf.PivotItems(i).Name, Worksheets("Email").Range("DivHeadTable"), 3)
.CC = Email_CC
.BCC = Email_BCC
.Subject = EmailSubject & pf.PivotItems(i).Name & ": " & EmailDate
.Attachments.Add NewFile
.Body = "Dear " & EmailName & "." & vbLf & vbLf & " Please find attached the report issued as at " & EmailDate & EmailBody

Any help would be greatly appreciated I'm still learning VBA so please excuse any thing that could be done better!

Thank you, Richard.

 

[Georgiboy]

Might be worth having a look through the below thread.

Sending Emails with Signature

 

[Richard1982]

Ah thank you I have solved my problem now