olemail

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

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

All, I have this code that creates email and copy stuff from excel. I'm trying to copy the cells and I want to be paste in the email as a picture or as a text. I got to the point where everything is done but missing the step to paste the cells a copied. Please I need help. Dim olapp As...

Hi guys, I have this code that automatically sends emails from my excel model on outlook. Can anyone suggest a straightforward (or otherwise) tweak that will enable it to send attachments?? Code: Sub SendRunRequest() Dim Msg As String Dim olApp As Object Dim olEmail As Object Dim...

HI Guys, My code below is creating a message in Outlook using excel macro. The problem is that the formatting of the letter is breaking down once i run this code. I'm not sure what the proper syntax to use. Hope you could help me out on this guys. Thank you. Sub EmailHelper() Dim olApp As...