![]() If you want to see how it's done, go directly to the video below. To create and use email signatures in Outlook on the web, see Create and add an email signature in or Outlook on the web. Do you think i can just somehow make the VBA code recognize the signature from excel? Or just change setting in outlook, it is just showing up in the top instead of bottom of the email.Important: If you have a Microsoft account, and you use Outlook and Outlook on the web or Outlook on the web for business, you need to create a signature in both products. The body of the email, subject, everything is in excel. & "Let me know if you have any questions. 'MsgBox ("you Mail has been sent to " & SendID)ĭim SendID$, CCID$, Subject$, Body$, sig$ 'it will be changed to the correct cid when its sent. 'change the src property to 'cid:your image filename' 'Now add it to the Html body using image name ![]() Attachments.Add "C:\ Image4.PNG", olByValue, 0 Attachments.Add "C:\ Image3.PNG", olByValue, 0 Attachments.Add "C:\ Image2.PNG", olByValue, 0 ![]() Attachments.Add "C:\ Image1.PNG", olByValue, 0 'add the image in hidden manner, position at 0 will make it hidden Subject = mainWB.Sheets("Mail").Range("B3").Valueīody = mainWB.Sheets("Mail").Range("B4").Value SendID = mainWB.Sheets("Mail").Range("B1").ValueĬCID = mainWB.Sheets("Mail").Range("B2").Value Set olMail = otlApp.CreateItem(olMailItem) Set otlApp = CreateObject("Outlook.Application")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |