Default Outlook Signature when generating email from VBA

kgkev

Well-known Member
Joined
Jun 24, 2008
Messages
1,247
I have done a good bit of searching to modify some existing code to include the default outlook signature, but I haven't had any luck.
Any help is appreciated

I have cut the code to barebones in an effort to simplify.

Code:
Sub create_Email_test()    
    Dim oApp As Object
    Dim oMail As Object
  
    Set oApp = CreateObject("Outlook.Application")
    Set oMail = oApp.CreateItem(0)
    With oMail
        .TO = "test@test.com"
        .Subject = "TEST"
        .HTMLBody = "Dear Sir or Madam," [COLOR=#ff0000]'ADD SIGNATURE HERE[/COLOR]
        .Display  
    End With
     
    Set oMail = Nothing
    Set oApp = Nothing
End Sub
 
Last edited:

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

kgkev

Well-known Member
Joined
Jun 24, 2008
Messages
1,247
Turns out I just had the .display in the wrong place

Code:
Sub create_Email_test()
    Dim oApp As Object
    Dim oMail As Object
  
    Set oApp = CreateObject("Outlook.Application")
    Set oMail = oApp.CreateItem(0)
    With oMail
        .Display
        .TO = "test@test.com"
        .Subject = "TEST"
        .HTMLBody = "Dear Sir or Madam," & "[BR]" & .HTMLBody
       
    End With
     
    Set oMail = Nothing
    Set oApp = Nothing
End Sub
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
65,919
Office Version
  1. 365
Platform
  1. Windows
Glad you sorted it & thanks for the feedback
 

Forum statistics

Threads
1,148,108
Messages
5,744,876
Members
423,907
Latest member
zerocool88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top