htmlbody

  1. Jyggalag

    Change my VBA code so it sends pdf file instead of excel file

    Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...
  2. Jyggalag

    Object out of range VBA error?

    Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag
  3. Jyggalag

    Email macro

    Hi all, I currently have this code: Option Explicit Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim...
  4. Jyggalag

    Make email macro send out separate emails

    Hi all, I currently have this setup in Excel: Sub send_email_complete() Dim outlookApp As Outlook.Application Dim SendEmailTo As Outlook.MailItem Dim source_file, to_emails, bcc_emails As String Dim i, j As Integer Set outlookApp = New Outlook.Application Set SendEmailTo =...
  5. Jyggalag

    Syntax error in mail body in vba?

    Hi all, I have the following code for HTMLBody: SendEmailTo.HTMLBody = "Dear all,<br/>" & "<BR>" & _ "bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text ""bunch of insignificant text"" bunch of...
  6. 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...
  7. W

    HTML Format Question

    Is it possible to specify a font and size and maybe color for only one line? 'sig ssig = vbLf _ & vbLf _ & vbLf _ & sname _ ' would like to specify font and size and color here only & vbLf _ & ttl _ & vbLf _ & " Division" _ & vbLf _ & "8120 Way" _ &...
  8. T

    macro to send email (outlook) from excel with table

    Hello, I need assistance sending an outlook email from an excel file with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial...
  9. M

    How to Programmatically Access Contents of a Table in an Outlook Invite

    Hi all, I'm working on a project where I need to somehow access the contents of a table embedded in an Outlook invite programmatically. If it were in an email, I'd be dealing with an object of the class "MailItem" and I could call HTMLBody and use the "table" tags to get the contents...
  10. B

    Bypass "Object Model Guard" when accessing a MailItem HTMLBody property

    Hi, here is what I need: to create a rule that when a certain email arrives, I want to forward the message, but before I do I have to edit the body to delete the first 3 lines of the email, If I use the MailItem.Body it doesn't work because the email loses its formatting properties such as...
  11. C

    Put an image in an HTMLBody for email

    Greetings! First, I just want to say I've never come here and not found an answer to any issue I was facing, either by posting (rarely) or by simply searching some keywords. This place is a goldmine! So, proper supplications having been performed, I now present this poser: I have a...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top