outmail

I need to send Column 1 (A2:A8) along with 1 of 9 columns, depending on the date in Row 2 - which I need to be yesterday (so Date-1). I have the following that will the email entire range A1:J8, which of course includes columns I don't need. <code style="margin: 0px; padding: 0px; font-style...

This code used to work with previous XP and Office versions. Now it does not create an email as it should. I've searched and it looks to me that the code is all still correct. And the Macro does not throw any error, it just doesn't make the email. It just goes merrily along like it wasn't even...

Hello, I currently have a UserForm showing when opening a workbook. A copy of this workbook is sent to Outlook with a Macro. The problem I am having is that the UserForm is showing when the copy is made thus requiring the user to close the form before the email is displayed. I don't know where...

Hi everyone, I'm at a bit of a loss with this one as the code I'm using I've used before without issue. My goal is to have Excel move a worksheet to a new workbook, save that file and send it and then kill the file. All the code is working apart from the code to send an email, when I've took...

Two questions for this one. First question: I have this code that I’ve been messing with. I have it displaying my message the way that I want, but I would like two parts of it to be Hyperlinks. Sub Workbook_AfterSave(ByVal Success As Boolean) If Success Then Dim OutApp As...

Hi All I hope that somebody can help me if this is possible. I am new at this :smile: so please bear with me. I am sending emails with the code below and it works fine. What I would like to do is save those emails to my drive for record purposes. Is this possible :confused: Thanks Preston...

I have a button in a spreadsheet that executes the code below. This spreadsheet is emailed to out to people and when they open it fill out a few cells I need the code to save there information then execute the email code below. Im not sure how to do this since the spreadsheet is opened up from...

Hello Everyone, I am hoping someone can help, I have setup some VBA to send out Documents via a list of people and addresses within my Excel List, this works fine for most areas, but I have one area that needs a custom Body of text per email and I am unsure on how to do this. Here is my code...

Hello, Could you please help me? I would like to delete sheet where it contain all the emails which should be use in my VBA. To do it, I wrote all emails inside of VBA. Example: Sub email () Dim OutApp As Object Dim OutMail As Object To_Austria = "xxxx@gmail.com";"yyyyy@gmail.com;"...

Sub sendmail() Dim OutApp As Object Dim OutMail As Object Dim rng As Range Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) ReportDirectory = Range("rngReport") ReportSavePath = ReportDirectory RngEmailTo =...

Hi Everyone, I am hoping someone will be able to help me out on the below, as I am stumped and only so long I can stair at my screen with a blank expression as I pour through google/ forums with no luck :laugh: So as the title suggests I am setting up a mail merge tool, and I have got it...

Hello Everyone I have an excel userform which generates an email and populates it with information the user has inputted within the various textboxes. The code works fine until the information within a textbox exceeds a certain length. I understand there is a way to lock column sizes with...

Hi I need to send a mail from an Excel. A signature must be added at the end of this mail. The signature is not the standard signature set in Outlook. So every user added an extra (personalised) signature -Study- with the same name, so I can call this specific signature name. So far so good...

hello , i use the following email template :- Option Explicit Sub PC_Email() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim MailAttachments As String Dim cell As Variant ' Not previously DIM'd...

Good evening, I have the following VBA code which opens up from Excel, an outlook outgoing mail and attaches a specific excel attachment located in the S drive. How can I incorporate a message box (in the below code) to notify if the attachment cannot be found in the location? Many thanks...

Why can I not get data into this email ? Sub Mail_Selection_Range_Outlook_Body() Dim rng As Range Dim OutApp As Object Dim OutMail As Object Set rng = Nothing Set rng = Selection.SpecialCells(xlCellTypeVisible) Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0)...

Hi there. The code I've compild her crashes Excel, and I can't figure out whats wrong with it. I can open excel excel an other codes just fine. Isuspect it has something to do with sending multipe mails. Ive rand the code through the step through method, and it seems to work. Any help...

hello, I currently use :- Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = "" .CC = "" .BCC = "" .Subject = "This is...

hi I have the 2 codes below but i want them to be added into the same module, as the count code below is in a command button and the email one is in a module how can i combine both codes into the module please? Private Sub CommandButton8_Click() Range("Z1").Value = Range("Z1").Value + 1 End Sub...

Hello, I have been searching the internet for sometime nowand cannot find solutions to my problems. I have the code below which generatesand email for me which works great! But I am just perhaps being picky about acouple items and hoping maybe someone can provide a solution to them...