{"id":4918,"date":"2016-12-24T08:11:12","date_gmt":"2016-12-24T08:11:12","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4918"},"modified":"2022-08-12T11:39:53","modified_gmt":"2022-08-12T11:39:53","slug":"image-in-signature-not-displayed-mail-sent-by-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/","title":{"rendered":"Image in Signature not Displayed – Mail Sent by VBA"},"content":{"rendered":"

Dear Friends,<\/p>\n

I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In order to get rid of this problem there are two solutions.<\/p>\n

\"outlook<\/a>

outlook Signature with image<\/p><\/div>\n

Method 1 : A Trick while displaying the HTML signature (Applicable for any Signature)<\/h2>\n

Before we jump in to the solution, lets see what goes wrong when we try to display a signature with Image via VBA code. As I had explained in my previous post, How to add signatures from outlook before sending an email via Excel VBA?<\/a><\/strong><\/i><\/p>\n

Outlook stores all the Signatures in AppData folder in windows in different format like Text, HTML etc. Therefore to display an HTML Signature, first we find the HTML file, read the whole HTML file and append it at the end of the mail body. This is exactly where the problem was when a HTML signature had an Image.
\nAll the texts are part of HTML but as you know for image, HTML has a tag where you provide the path where image is located. All the images are stored in a separate within the Signature folder as you can see in the below picture.
\n\"Image<\/a><\/p>\n

Note: <\/strong>In HTML, if the files are within the same folder where your HTML file is then you do not need to provide the complete path, rather you just give the folder name and file name. HTML by default look for that folder and image within the same directory. This is how outlook reads it and displays the images in mails.
\nBut when we read it from HTML via VBA then this image URL becomes unknown for outlook to display the image in Signature. I hope you understood the problem.<\/p>\n

Now you know the problem, then solution is simple :<\/p>\n

Solution<\/h1>\n

Before we use the HTML code for signature at the end of Mail body, we need to change all the path (incomplete URLs) with complete URLs.<\/p>\n

Read my comments in the code where I have made the changes.<\/p>\n

Method 1: Any Outlook Signature with Image<\/h1>\n
\r\nSub With_HTML_Signature_With_Image()\r\n\r\n    'Do not forget to change the email ID\r\n    'before running this code\r\n\r\n    Dim OlApp As Object\r\n    Dim NewMail As Object\r\n    Dim EmailBody As String\r\n    Dim StrSignature As String\r\n    Dim sPath As String\r\n    Dim signImageFolderName As String\r\n    Dim completeFolderPath As String\r\n\r\n    Set OlApp = CreateObject("Outlook.Application")\r\n    Set NewMail = OlApp.CreateItem(0)\r\n    \r\n    ' Here Since we are talking about\r\n    ' the HTML email then we need to\r\n    ' write the Body of the Email in\r\n    ' HTML.\r\n\r\n    EmailBody = "Hello Friends !!" & "\r\n\r\nWelcome to LearnExcelMacro.com" & vbNewLine & _\r\n    "Here i will make you awesome in Excel Macro.\r\n\r\nYou can mail me at info@learnexcelmacro.com"\r\n\r\n    '*****************************************************\r\n    '                    Important\r\n    '*****************************************************\r\n    ' go to the appdata path as mentioned in\r\n    ' the above important point. Check the name of\r\n    ' the signature file. For example: here in my system\r\n    ' the signature's file name is vish.txt, vish.htm\r\n    ' Therefore before running this code, check the\r\n    ' name of the signature file in your system and\r\n    ' replace vish.txt with your file name.\r\n    '****************************************************\r\n\r\n    sPath = Environ("appdata") & "\\Microsoft\\Signatures\\Default.htm"\r\n    ' Files folder name is always same name as html file name appended by\r\n    ' "_files"\r\n    signImageFolderName = "Default_files"\r\n    ' in outlook HTML forward slashes are used for\r\n    ' the file path\r\n    completeFolderPath = Environ("appdata") & "\\Microsoft\\Signatures\\" & signImageFolderName\r\n\r\n    ' If the path and file name given by you is not\r\n    ' correct then code you insert a blank Signature\r\n    \r\n    If Dir(sPath) &lt;&gt; "" Then\r\n        StrSignature = GetSignature(sPath)\r\n        ' Now replace this incomplete file path\r\n        ' with complete path wherever it is used\r\n        StrSignature = VBA.Replace(StrSignature, signImageFolderName, completeFolderPath)\r\n    Else\r\n        StrSignature = ""\r\n    End If\r\n\r\n    On Error Resume Next\r\n    With NewMail\r\n        .To = "info@learnexcelmacro.com"\r\n        .CC = "info@learnexcelmacro.com"\r\n        .BCC = "info@learnexcelmacro.com"\r\n        .Subject = "Type your Subject here"\r\n        ' Here at the end of the Email Body\r\n        ' HTML Signature is inserted.\r\n        .htmlBody = EmailBody & StrSignature\r\n        .display\r\n        .send\r\n    End With\r\n    On Error GoTo 0\r\n    Set NeMail = Nothing\r\n    Set OlApp = Nothing\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
Important : Do not Forget<\/h1>\n
Do not forget to copy paste the below function in your module
\nFunction to read the Signature file and return the Signature Text<\/strong><\/p>\n
\r\nFunction GetSignature(fPath As String) As String\r\n    Dim fso As Object\r\n    Dim TSet As Object\r\n    Set fso = CreateObject("Scripting.FileSystemObject")\r\n    Set TSet = fso.GetFile(fPath).OpenAsTextStream(1, -2)\r\n    GetSignature= TSet.readall\r\n    TSet.Close\r\nEnd Function\r\n\r\n<\/code><\/pre>\n
Method 2 : Simple and Easy Trick (Only for Default Signature)<\/h1>\n
All you need to do is, in your VBA code, before you assign a Body of your email, display it once on the screen. As soon as VBA displays the mail on screen, outlook, by default, adds its default signature at the end of the body of your email.<\/p>\n
Every time before sending the email, if you display your mail, you can see this method will be slow. Therefore it is not good for sending bulk emails in a loop. By the way this method, can be used for all type of signatures (Text, HTML, image etc.). But important to note than this is applicable for Default Signature in outlook only<\/strong><\/p>\n
Important<\/strong> .Display statement should be used anywhere but before the Email Body statement as explained above. If you display your email after putting the email body, then outlook will not append the default signature at the end of your email body.<\/p>\n
\r\nSub Outlook_Default_Signature_With_Image()\r\n\r\n    'Do not forget to change the email ID\r\n    'before running this code\r\n\r\n    Dim OlApp As Object\r\n    Dim NewMail As Object\r\n    Dim EmailBody As String\r\n    Dim StrSignature As String\r\n    Dim sPath As String\r\n\r\n    Set OlApp = CreateObject("Outlook.Application")\r\n    Set NewMail = OlApp.CreateItem(0)\r\n    \r\n    ' Here Since we are talking about\r\n    ' the HTML email then we need to\r\n    ' write the Body of the Email in\r\n    ' HTML.\r\n\r\n    EmailBody = "Hello Friends !!" & "\r\n\r\nWelcome to LearnExcelMacro.com" & vbNewLine & _\r\n    "Here i will make you awesome in Excel Macro.\r\n\r\nYou can mail me at info@learnexcelmacro.com"\r\n\r\n    On Error Resume Next\r\n    With NewMail\r\n        .To = "info@learnexcelmacro.com"\r\n        .CC = "info@learnexcelmacro.com"\r\n        .BCC = "info@learnexcelmacro.com"\r\n        .Subject = "Type your Subject here"\r\n        ' Important! Before writing the body of your email\r\n        ' you should display the mail\r\n        .display\r\n        ' Here at the end of the Email Body\r\n        ' HTML Signature is inserted.\r\n        .htmlBody = EmailBody\r\n        .send\r\n    End With\r\n    On Error GoTo 0\r\n    Set NeMail = Nothing\r\n    Set OlApp = Nothing\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n<\/span>","protected":false},"excerpt":{"rendered":"
Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In order to get rid of this problem there are […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5205,1676],"tags":[],"class_list":["post-4918","post","type-post","status-publish","format-standard","hentry","category-send-email","category-excel-tips"],"yoast_head":"\nSignature Image Appearing as Red Cross in Email Sent by Excel VBA<\/title>\n<meta name=\"description\" content=\"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Image in Signature not Displayed - Mail Sent by VBA\" \/>\n<meta property=\"og:description\" content=\"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-24T08:11:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:39:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Image in Signature not Displayed – Mail Sent by VBA\",\"datePublished\":\"2016-12-24T08:11:12+00:00\",\"dateModified\":\"2022-08-12T11:39:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\"},\"wordCount\":571,\"commentCount\":25,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png\",\"articleSection\":[\"Email\",\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\",\"name\":\"Signature Image Appearing as Red Cross in Email Sent by Excel VBA\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png\",\"datePublished\":\"2016-12-24T08:11:12+00:00\",\"dateModified\":\"2022-08-12T11:39:53+00:00\",\"description\":\"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Email\",\"item\":\"https:\/\/vmlogger.com\/excel\/send-email\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Image in Signature not Displayed – Mail Sent by VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Signature Image Appearing as Red Cross in Email Sent by Excel VBA","description":"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/","og_locale":"en_US","og_type":"article","og_title":"Image in Signature not Displayed - Mail Sent by VBA","og_description":"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email","og_url":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2016-12-24T08:11:12+00:00","article_modified_time":"2022-08-12T11:39:53+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Image in Signature not Displayed – Mail Sent by VBA","datePublished":"2016-12-24T08:11:12+00:00","dateModified":"2022-08-12T11:39:53+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/"},"wordCount":571,"commentCount":25,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png","articleSection":["Email","Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/","url":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/","name":"Signature Image Appearing as Red Cross in Email Sent by Excel VBA","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png","datePublished":"2016-12-24T08:11:12+00:00","dateModified":"2022-08-12T11:39:53+00:00","description":"Two solutions to solve the problem of image not displaying in Outlook signature while sending email via Excel macro. Excel VBA to add signature with image in Email","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/12\/Outlook_Signature_With_Image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2016\/12\/image-in-signature-not-displayed-mail-sent-by-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Email","item":"https:\/\/vmlogger.com\/excel\/send-email\/"},{"@type":"ListItem","position":3,"name":"Image in Signature not Displayed – Mail Sent by VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4918"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4918"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4918\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}