omail

  1. A

    VBA code to add company logo at the end of the email with attachements

    Hi I have a macro which I wrote from watching a couple of YouTube videos, it works however, I would like to add the company logo at the bottom of the email, the image is saved in W:\company\logo.jpg. My codes are as follows: Sub send_email_with_attachments() On Error Resume Next Dim o As...
  2. K

    Default Outlook Signature when generating email from VBA

    I have done a good bit of searching to modify some existing code to include the default outlook signature, but I haven't had any luck. Any help is appreciated I have cut the code to barebones in an effort to simplify. Sub create_Email_test() Dim oApp As Object Dim oMail As Object...
  3. V

    Only run macro if the first column contains text - VBA Excel to Outlook

    Hi All, This is my current code: 'binding Sub bulk_email() On Error Resume Next Dim o As Outlook.Application Set o = New Outlook.Application Dim omail As Outlook.MailItem Dim Signature As String Dim i As Long For i = 2 To Range("A10000").End(xlUp).Row Set omail =...
  4. J

    Office 365 proplus

    i have this code for template when run get error we cannot opened, and highlight this line of the code: Set oMail = Application.CreateItemFromTemplate(strTemplate) complete code: Public lstNum As Long Public Sub ChooseTemplate() Dim oMail As Outlook.MailItem Dim oContact As...
  5. W

    Run-time error for different users

    Hi, I added a Macro to my workbook which, when run, takes the current worksheet, saves it as a temporary file, emails it out and then deletes the file. It works fine for me but when another user tries to run it, they get the error message: Run-time error '1004': Method 'SaveAs' of...
  6. W

    Colour Distortion when Macro Run

    Hi, I have a VBA which takes the current worksheet and emails it out (code shown below). However in the new file it creates and attaches to the email, the colours are distorted and not the same as the original worksheet. Does anybody know how to prevent this from happening. Many thanks Sub...
  7. N

    Send HTML email through Excel and Outlook 2016 with default signature

    Hello everybody, OK, here's the thing, I know how to send the email, problem is, when I try to add the DEFAULT signature. If I leave it as is, the body doesn't show up, and when I get it to show the body of the message, the signature won't come up. Sub Mail1() Dim...

This Week's Hot Topics

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