.htmlbody

  1. T

    Inserting a table into HtmlBody of email in vba

    I'm trying to insert a table whose content are contained on a spreadsheet (Let's say within the range A1:D4 as an example) into an email. I've written the body out in HTMLBody format and have followed the instructions from this guide to insert the table: Convert Excel Range Into HTML Table...
  2. B

    VBA HTMLBody with String not working.

    Hello, I am trying to write a code that will send an email with a specified body as a string in this code its dim as strbody and i want the the HTMLBODY to include my outlook signature. I can only get on or the other to work but never both at the same time. The code sample below is just...
  3. Z

    VBA - Userform - dataform into excel attachment

    Hi all, Wandering if anyone can point me in the right direction. I created a vb userform for people to input data. It is basically a bunch of fields, then the vba macro will create an email with some pre-defined settings, and then put the data in the email as a table and then send to...
  4. T

    VBA Send_Emails() Help

    Happy Friday, I have a sheet to send monthly and I want to create a button and a code to send it to the same people every month. The button works but the code isn't EXACTLY how I want it. Here are my issues: 1) My signature is not showing up 2) I can't get the font to be Arial, 11. Sub...
    • Tvalli
    • Thread
    • .attachments.add .htmlbody dim end outlookmail
    • Replies: 1
    • Forum: Excel Questions
  5. N

    VBA code .HTMLBODY issue

    Hello folks I am looking for some help with a problem that although small, is very frustrating :eeek: I have some VBA code that essentially reads a spreadsheet and create an email. the code works fine at home (Windows 10 pro), but at work (also Windows 10 pro), I get an error of Run-time error...
  6. C

    EXCEL 2016 Send an email with signature

    I need to compose emails using VBA with signature in EXCEL 2016. I followed an tutorial on YouTube. This is the code I used, exactly same as the youtuber's but it works on his computer, not mine. Sub PrepareEmailNow() Dim olApp As Outlook.Application Dim olEmail As Object Dim sig...
  7. S

    .HTMLBody VBA code to attach a picture (PNG)

    Hi, I’m trying to attach a picture/PNG file to An email via VBAcode using .HTMLBody but want to set the location of picture not within theHTML statement: Currently: .HTMLBODY = "<HTML>******><imgalign=baseline border=0 hspace=0 src='C:\Users\ documents\Reporting\MacroTest\New...
  8. S

    using .htmlbody instead of .body in my email excel sheet macro using OutMail

    In the code below I specify the body of the email using a series of cell references from my workbook. Can I use the same approach and use .HTMLbody instead of .Body. I want to be able to format the body of my message or make it appear more aesthetically pleasing for the recipient A line below...
  9. Roderick_E

    VBA .send vs .display signature

    In my code snippet below I am checking checkbox2 to see if the user wants to display the email before sending. If TRUE, just send without display. Unfortunately if it sends without display, the person's default signature doesn't get included in the email. WHY??? I don't understand. Please...
  10. S

    Help with inserting image into email body using .HTMLBody

    I have been held up by a simple glitch in my email loop code. I can't seem to get the correct code to insert a image into the body using .HTMLBody. I am using a loop to grab email addresses (both .To and .CC), salutations, attachments and the image that I would like inserted into the body of...
  11. W

    VBA not including duplicate e-mail addresses

    This is driving me crazy and I really need someone to give me a lifeline here :) I have a VBA code for Excel that populates information in outlook e-mails based on certain cells. The problem is the code works flawlessly, unless it runs into a duplicate e-mail! It will only send out one e-mail...
  12. R

    VBA : Outlook Email formating :: Table

    Dear All, I have below sub for creating the email - from data inputted in user form I would like to know whether it is possible to convert the list of Case details in tabular format instead of list. Sub Send_Email() Dim olApp As Outlook.Application Dim olemail As Outlook.MailItem Dim...
  13. T

    Embedded Picture in Excel File- Need it to show on Email with HTMLBody

    I currently have a Macro that will Send an email Automatically in Outlook. I use .HTMLBody. The Email needs to include a picture after the text. I have it working with <img src...=""> pointing to a jpeg on a Server. However, it's slow as it takes several seconds for the picture to open once...
  14. P

    Pasting cells from multiple sheets into an email help please

    Hi, i hope you can help again beginner at this and still learning :), i havethe code below which i have put in for command button, so when clicked it copiein the cells from a - k and only data that hasi want to do this multiple times heading above the code, but the below isnt helping any chanyou...
  15. F

    Excel auto email from Outlook going from Office '07->'16

    Hi folks! We've just updated from Windows 8/Office 2007 to Windows 10/Office 2016 at work. Some time ago I created a help file for invoice posting that had a built in auto email feature if certain conditions were met. To my horror I now realize that the auto email that Excel sent through...
    • frosen
    • Thread
    • .htmlbody email excel outlook 2016 vba & excel 2016
    • Replies: 0
    • Forum: Excel Questions
  16. T

    Adding Named Range to Body of Email

    What i need to just a simple way to get a group of cells to copy into my body of the email. I have tried this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("A15..B21") And this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("TURNUP") But both...

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
Back
Top