outmail

Hello, Can someone look at this code and help me with a reference? I am trying to grab an email address from another open workbook and have it insert into the "TO:" location in the email. I'm getting stuck on what I'm doing wrong or what's missing. The email address is located in cell D33 which...

Hi all, I must admit I am not even sure I am describing this with all of the correct terms- so please forgive me in advance... I have a workbook that uses buttons to send various emails. This workbook is used by multiple users- the users have multiple email boxes tied to the accounts they are...

Hello folks, I am hoping someone might be able to help out with some VBA code. I have the following code, which works fine for the first row. After it has completed that row I want it to move to next row until the cells are blank. I think I need to set the range as an integer, but I am not...

Hello All - I have been using a script to send two different emails generated from the same information on my spreadsheet. The VBA code that I have has been working perfectly until just recently (maybe couple of weeks ago). Now, the second email that gets generated is....not onFocus I guess...

Hi Folks, back after a long time. I am hoping someone can help me with this... I have a VBA script which will send out emails from excel. It had two images and one table embedded on the mail body Plus a pdf attachment with the entire thing (two images and one table) On outlook (that's what is...

I was trying to add a couple line in the code below to have a link that would take someone to the file location. I have the problem area highlighted in Red. I cant seem to get the info entered without an error. Sub REVISED_REQ() 'For Tips see...

hi, I have this code below and it sends an email, but for only one record. I am not able to send multipal emails of multipal records. code:- Sub Table() Dim rng As Range Dim OutApp As Object Dim OutMail As Object Set rng = Nothing On Error Resume Next 'Only the visible...

Hi, I'm trying to generate a macro email with my current signature but the picture is not showing correctly. The picture in my current macro can be shown in the link below. https://drive.google.com/open?id=1d4t2_k55WMWZTCGZe47b9sWwy6EOfTmP Here is my code. Function GetBoiler(ByVal sFile As...

Hi All, I have each of the codes to do what I said above...however I cant make them work together. I want the code to: First - Save excel file based on Cell C:6 Second - Draft Up An Email Automatically in Outlook Third - But I dont want it to send automatically, I just want it to draft it open...

Hi, I am struggling to loop through my sent range to send an email via outlook with attachments. so far I have coloum N email 1 email 2 email 3 email 4 email 5 Sub projtodat ()Dim OutApp As Object Dim OutMail As Object Dim Rng As Range Set Rng = Range(Range("N2"), Range("N2").End(xlDown))...

Howdy, I'm trying to paste a selected range as an image to an email via VBA a la this post. I have the code working, for the most part. However, the image that gets pasted is blank. If I single step with F8, the code works, but when I run it like normal, it's blank. I'm completely lost as to...

The below macro triggers a compile error in excel 2010. I am not great with macros, so any insight would be appreciate. The macro copies part of a workbook and pastes it as a picture in the body of an email and sends it. Sub FRIMail() Dim r As Range Set r = Worksheets("Fri").Range("A1:M69")...

Hi, I have a mail macro that automatically sends email based on a cell value in Excel. So what this is supposed to do is auto mail when cell C2 is larger than 0. This is working as it should. The problem here is that the values are gathered with formulas, "=COUNTIF(Utleveranser.Data!B:B, 1)"...

I have a list of e-mail addresses in column D. Column B populates from a query as mileage reports are received from employees. Until a report is received and captured by the query, the cell shows "#N/A" (A VLookup with no result yet.) I would like to send a single e-mail reminder to all...

Why is it that this code will show the signature ONLY if I enable .display? I'd like to just .send without .display. TECH: This loops through rows 2-3 and creates an Outlook mail object, to which it adds to,cc,bbc,subject,body and then emails Sub Mail_Outlook_With_Signature_Html_1() ' Working...

So this is a piece of code, that runs in a different workbook, as part of the same system, perfectly fine. However will not function as required in this workbook. This doesn't throw an error, but when hovering over "ActiveWorkbook.FullName" in the .Add code, it shows as <automation error=""> I...

Hey everyone, I put the below together and am having a problem. First I am new with macros, and am learning more every day, so maybe it is a simple fix.... The below will copy a cell range, and paste into an email that is sent to select recipients. When I change the ending to .display , the...

hiya folks. I have the following Macro running to send email to suppliers if orders are due or late Sub CommandButton1_Click() Dim OutApp As Object, OutMail As Object Dim rng As Range Dim StrBody As String StrBody = "Please see below Live PO's requiring confirmation & updates...

Hi, I have this VBA that works great. It convert a specific range in active worksheet and attaches as PDF to email. Now I'm trying to also add the same range to the body of the email. Any advise? Sub SendPDF() ' Create PDF and send as attachment. Dim strPath As String, strFName As...

Hello all I hope you can help on this please This code sends out emails from the contact list which works fine and takes the body of the email content from range G1:G53. What I am trying to do is change the font to Bold from Range G14:G23. Any ideas please [Sub Test1() Dim OutApp As...