omail

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...

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...

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 =...

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...

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...

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...

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...