Help sending email but removing signature via VBA

[molonlabe]

I have my primary email and then I can send from another (Alt email), but that alt email is not an account that is added to my outlook, but I can send/receive from it. Hope that makes sense. Since the alt email account is not added, then I can't set it to have a default signature. Therefore I use this code to open a template and change the sending from. Problem is that it still adds the default signature. Before I could alter the registry to stop this, but I can no longer access the registry. I need a way to open the template without adding my default signature. Can anyone help!?

'Opens Email Disclosure Template
Sub OpenEmailTemplate()
Dim oAccount As Outlook.Account


For Each oAccount In Application.Session.Accounts
   ' If oAccount = "testATtest.com" Then
Set temp = Application.CreateItemFromTemplate("file path here")
temp.SentOnBehalfOfName = "sendATtest.com"
temp.Subject = "PERSONAL AND CONFIDENTIAL COMMUNICATION"

temp.Display

'End If
Next
Set temp = Nothing
End Sub

 

[Diane Poremsky]

If you can't access the registry to add the key and no one will add it for you, you'll need to delete the signature in the macro - Remove Email Signature from Message using VBA

if you are replacing the signature, you either need to use filesystem object or Redemption.

 

[Diane Poremsky]

BTW, what content is in the template body? There might be a way to clear the body and insert the template- well, there are ways to do it, but depending on the situation, it might not be workable.

This inserts an HTML file into the body: Create a New Message using an HTML File or Stationery - that just happens to be the same way you'd add a signature to a message using vba: Insert or change an Outlook signature using VBA

 

[molonlabe]

Hey Diane, thanks!

yes, i'd love to just delete the signature but anytime I've tried with VBA, it deletes the entire body of the email. The template is just a formatted message with headers and an image. Below is the frame. There is a bit of content in each box and an image in the top box. Not sure if that helps at all.

 

[molonlabe]

I get an user-defined error type not defined for objDoc As Word.Document

*edit, I fixed this by going here Compile Error: User-defined type not defined

just in case anyone googles across to this post

 

[Diane Poremsky]

Look in the message source code - is there a bookmark for the signature? It would be called "_MailAutoSig" - if not, then it will be harder to delete the signature, but could be done using regex or possible Replace function.