Email remove outlook default message (1 Viewer)

D

Del Bloke

New member

Local time

Today, 10:55

Joined

Jan 13, 2014

Messages

2

• Jan 13, 2014

• #1

Hi,

I have created a form that allows the user to create an Outlook email message using a saved HTML template in VBA but the users default Outlook signature is added every time the message is sent.

Has anyone any suggestions on how to remove the default signature from the message body?

 

G

GSSDevelopment

PHP Guru

Local time

Today, 05:55

Joined

Dec 31, 2012

Messages

58

• Jan 13, 2014

• #2

Del Bloke said:

Hi,

I have created a form that allows the user to create an Outlook email message using a saved HTML template in VBA but the users default Outlook signature is added every time the message is sent.

Has anyone any suggestions on how to remove the default signature from the message body?

Click to expand...

The auto-insert signature is stored in the hidden Word bookmark called _MailAutoSig

Code:Copy to clipboard

Sub DeleteSig(msg As Outlook.MailItem)
    Dim objDoc As Word.Document
    Dim objBkm As Word.Bookmark
    On Error Resume Next
    Set objDoc = msg.GetInspector.WordEditor
    Set objBkm = objDoc.Bookmarks("_MailAutoSig")
    If Not objBkm Is Nothing Then
        objBkm.Select
        objDoc.Windows(1).Selection.Delete
    End If
    Set objDoc = Nothing
    Set objBkm = Nothing
End Sub

Source

Cheers

 

D

Del Bloke

New member

Local time

Today, 10:55

Joined

Jan 13, 2014

Messages

2

• Jan 13, 2014

• #3

Thanks GSSDevelopment, it works a treat.

I also had to add Word in tools/references of VBA and then Call DeleteSig(msg) after displaying the item.

Many thanks

 

M

MS16

New member

Local time

Today, 05:55

Joined

Apr 6, 2016

Messages

1

• Apr 6, 2016

• #4

Hi,

I'm very new to using Visual Basic for Outlook 2010. I am trying to create a .oft file that automatically deletes the signature so that the body of the email is blank. Would you know the code I would use to do that in the Visual Basic editor?

Thanks,

Mark