outapp

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

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

Hi All, I'm using this code to generate an email to send: Sub sendemail() Dim FileExtStr As String Dim FileFormatNum As Long Dim Sourcewb As Workbook Dim Destwb As Workbook Dim TempFilePath As String Dim TempFileName As String Dim OutApp As Object Dim OutMail As...

Hello I would like to take the data from my workbook and copy and paste these data into an email in outlook. I have that code already but it does not seem to be enough. Sub Mail() Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application")...

Hello Hello Excel Geniuses I have found MANY answers to the first part of my problem..... I would like to email my full workbook to multiple users [solved] BUT...I would like to e-mail it to each individual separately..... the below is working for multiple and 1 e-mail recipient if you are...

Hi guys, I am trying to send an email from excel 2013 based on the data in the spreadsheet. I currently have an active button on each row with a macro assigned. This works perfectly, however, I would like to be able to only have one button per sheet that will create the email based on the...

I have the following code, which works fine, except that the active workbook is not being attached to the outlook email created Kindly amend my code Sub Email_Report() ThisWorkbook.Activate 'start in THIS workbook ztext = [bodytext]...

Hi guys, Good day. Can you help me on this. When I click the command button the outlook mail will automatically appear with an attachment, however I want the excel sheet on that excel file have been deleted(Sheet 1 or 2). Code: Dim OutApp As Object Dim OutMail As Object Dim...

Hi all, I have a button on my spreadsheet that is supposed to allow the user to send it as an attachment to a specified address once the user has filled out some required fields. Tee problem is that the e-mail message is generated and sent successfully, but the spreadsheet is not attached...

Hi, I have written a VBA macro that will mail a form to an address. see below. I want to add a statement that will prevent the form form being emailed and give an error message if certain fields are not complete - A4, B6, C12. Any suggestions? Sub Mail_small_Text_Outlook() Dim OutApp As...