' name of the signature file in your system and "Here i will make you awesome in Excel Macro.
Body = EmailBody & vbNewLine & vbNewLine & StrSignatureĮmail and Signature with HTML Body and HTML SignatureĮmailBody = "Hello Friends !!" & " Welcome to " & vbNewLine & _
CREATE OUTLOOK EMAIL VBA CODE
' correct then code you insert a blank Signature ' If the path and file name given by you is not SPath = Environ("appdata") & "\Microsoft\Signatures\vish.txt" ' name fo the signature file in your system and ' Therefore before running this code, check the ' the signature's file name is vish.txt, vish.htm Set OlApp = CreateObject("Outlook.Application")ĮmailBody = "Type the Body of your email"
We will see the code of both the above methods below one by one: Here there could be two types of Email and Signatures:
Set TSet = fso.GetFile(fPath).OpenAsTextStream(1, -2)īelow is the code to create the Outlook Email with the Signature at the end. Set fso = CreateObject("Scripting.FileSystemObject") Thus we need a function which read and return the Signature Texts from the file wherever we need to insert it in the body of the Outlook email.įunction to read the Signature file and return the Signature Textįunction GetSignature(fPath As String) As String If yes then we are reading the text from the signature file and inserting that signature in the email. In the below code we are first checking if these files exists and have some values in it.
0 kommentar(er)
