I am trying to add my Outlook signature that has an image with text (i.e. HTML format) and refer specific cell (i.e. .HTMLBody = Range ("B5"). Value) using Macro to return the Outlook Signature with Email body text that is written on cell B5.
I used Ron de Bruin's code (Insert Outlook...
I need help adding my default outlook signature at the end of my VBA.
The following codes I obtained and adjusted from this forum generates my email body to include a table in the body from my excel file:
Private Sub CommandButton1_Click()
'Send NSCC Deposits email directly from Daily Cash...
I am using the below code in a MS Office 2000 environment.
Does anyone know how to set the email type to be HTML and also automatically attach the signiature from outlook.
I am using the following standard code to send.
Set myOlApp = CreateObject("Outlook.Application")