outmail

hi all, i have a following VBA but it keeps trowing a runtime 438 error object doesn't support property or method. ms outlook library 16.0 is active file saving works, just can launch Outlook and send. Any ideas? Public Sub SaveAndSendPDF() Dim OutApp, OutMail As Object Set OutApp =...

Hi Excel genius'! I need a variation of the following code to use a range of cells as the email body. I have the following that adds the signature, but does not add the range of cells. Is this able to be modified to add the cell range? Thank you to all who can assist with this :) Dim...

Hello, I have code for sending an email but I want to add a condition to it. What am I missing? If the date in A2 = todays date, send the email. Sub auto_mail() Dim OutApp As Object Dim OutMail As Object Dim r As Range Dim cell As Range Set r = Range("A2")...

Hello Everyone, I'm using outlook 2016 and Excel 2016. I have written a code to paste a email in the outlook body, the code works fine however I'm not able to paste the image in the email body. Please help. Please find the vba code below. Sub Send_Mails() Dim OutApp As Object Dim...

I want to save the email in my local folder, and I saw this link https://www.mrexcel.com/forum/excel-questions/361751-vba-saving-email-only-after-send-pushed.html which basically use the class module to save the email after sending it out. However the problem is, the email saved is the preview...

Hi all, I'm hoping you can help me solve a mystery. I have a button on a form that sends the sheet as an email attachment once it has been completed. The problem is that the email when received is blank and what had been filled out is no longer there. The code appears below. Any clues? Thanks...

Hi all, I am trying to write a VBA to create an Outlook Appointment in a shared calendar. The below code creates an appointment, but in my own default calendar. I would appreciate any help anyone can provide, as I am struggle to find an answer. Sub CalendarEntry() Dim OutApp As Object Dim...

So i have the below codes... When i hit F5 the code will run perfectly although i would like it to include cell A,B,C and D in the email body. But i want this to run every time the value of any cells in I going above 1.... Can anyone help as to whys it isnt running, kinda doing my head in now...

I have created VBA code that checks to see if certain cells on a form have been filled out and then attaches the excel sheet to an email. What I need to do is send the attachment as a pdf instead. I'm at a loss for how I would change the code (see below). Any suggestions appreciated. Thanks...

Hey, I am currently using this code that I found online and modified. It works great for emailing a range of data from a sheet, "Completion Summary". I was wondering if there was anyway to add in another sheet to be incorporated into the email. I like this way because it puts the sheet in the...

I have written a macro that sends a sheet as a csv file to an email address. What if I want to send it to an FTP site instead? Not sure how I would change my code. Any advice would be appreciated. Sub Mail_small_Text_Outlook2() If Range("c157").Value = "" Or Range("c159").Value = "" Then...

Hi good morning, I am struggling to get the 'Please note' wording to be in bold, on the .SBody line. Please can you help, i have tried the <b> but that didn't work. I hope you can advise me please? Sub Button3_Click() Dim OutApp As Object Dim OutMail As Object Dim sTo As String, sCC As...

Hello, Thanks for reading this. I'm trying to email a clickable link with VBA to outlook. I have the below code which does everything I need but the link that is emailed is not clickable. I is emailed as a hyperlink and the path is correct (if I past the path into the address bar the file...

Hi, I have columns on "healthcheck" sheet that gets updated daily, with the latest update on the last blank column. I am then trying to locate the last filled column and copy paste it to a separate sheet "export" so that I can select the range and have it go out as part of an email. But for...

I have a simple bit of code in Excel that creates an Email,adds an attachment and saves the email into the folder where the excel documentsits – easy enough so far. However it only saves the email in its ‘unfettered’state but I want it to save the email AND its attachments exactly as they...

Hi I have the following macro that works fine to send the active workbook to one recipient and one CC, with reference to two cells: Sub Mail_Workbook() 'Excel VBA to send mail. Dim OutApp As Object Dim OutMail As Object Dim str1 As String Dim str2 As String Dim str3 As String Dim str4...

Hi I am using the below code to email a Pivot Chart in the body of an email. I am getting a runtime 438 error. Any help would be appreciated. Sub ChartMail() Dim TempFilePath As String Dim TempFileName As String Dim OutApp As Object Dim OutMail As Object Dim Salu As String Dim BodyText As...

Hi, apologies Im a little new to this but I have a spreadsheet that is intended to automatically send an email based on the result of a formula. The code I have in ThisWorksheet for sending the email is: Sub Test1() Dim OutApp As Object Dim OutMail As Object Dim cell As Range...

Hi, I have a workbook containing multiple sheets. I have figured out a way to send the entire workbook as an email attachment in Outlook. it works great. What I need to do now is send just one sheet named ICIMS from the workbook as a CSV file attachment. Any ideas? Here's what I have so far...

Hello, I am still somewhat new to the VBA coding, but I have learned an extreme amount in the past few months. The background of what I am needing to accomplish is to send reports based on whether I have updated the report. I have already figured out how to make the email get the subject...