outlookapp

Hi All, Have the below code, almost there, but body text is currently going below the copied table and also want to add a signature. Code- to copy visible cells in range into email body.

Hi all, I was able to create a macro that allows me, with the push of a button, to send he Excel file to a certain address. Sub Mod_SendWorkbook() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0)...

Hello I am new of VBA. I can generate the pdf with new name every time, however i am not able to attached latest generated file in email. it is giving me me error " Path does not exist, verify the path in correct." here is the code. please help me expert Sub sendReminderMail() ChDir...

I'm currently trying to have the VBA running that will send the current files based on excel cells. I have a message error on the line : myAttachments.ADD "Sheet3.Cells(9, 2)" The cell B,9 currently have the following value : C:\Users\ojodoin\Desktop\Feuilledetemps.pdf which is where I want...

I've implemented the below VBA to use to send the form that it is for to a specifc emai address, but would like the VBA to populate the "SUBJECT LINE" of the email it generates with a concatenated cell from the workbook. The cell is identified as AM11. Is this even possible? Sub SendWorkBook()...

Hi there, I've a simple email script as follows: Sub Mail() Dim outlookApp As Outlook.Application Set outlookApp = CreateObject("Outlook.Application") Dim outlookMail As Outlook.MailItem Set outlookMail = outlookApp.CreateItem(outlookMailItem) With outlookMail .To =...

Dear Team, Can any body explain how to save the active sheet name with current date and windows user name. Also explain how to call the same in outlook. Private Sub CommandButton1_Click() ChDir "C:\TEMP" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...

I am using the following to send an email to multiple users but it will only send to two recipients no mater how many I add. please help and thanks in advance. Sub sendReminderMail() ChDir "Z:\Attendance" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ "Z:\Attendance\Weekly...

Hi there, I have a macro that extracts all outlook emails into an excel file. Is there a line of code or a setting that I can adjust to bypass Outlooks security popup that prompts me to "Allow" access for 1 minutes? Code as follows: Sub GetFromOutlook() Application.DisplayAlerts = False...

Hi there, The following code works on Excel 2013 but wont work on Excel 2010: Sub GetFromOutlook() Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As MAPIFolder Dim OutlookRecipient As Outlook.Recipient Dim OutlookMail As Variant Dim I As Integer Set...

Hiya Peeps, I wonder if someone can help me with this. I am trying to get the code to select the right data via autofilter, then email the sheet as a PDF. I have the following code: Sub Sort1() ' ActiveSheet.Range("$AB$4:$AB$350").AutoFilter Field:=1, Criteria1:=Array( _ "Care...

Hey, i have entered the following code and have absolutely no trouble executing, however, i dont know how to move it to the next row and perform the macro again. it basically is for sending emails....also i would like to update the excel sheet once the email is sent automatically...to say email...

i am using the below code to open and email and add the recipient based off cell values. I have been working all day to try to find a way to open 7 of the same emails but have them addressed to different people with one macro. any tips? thanks in advance! Sub Rectangle1_Click() Sub Mail()...

I have been using the below code for sending an Email from Excel for many years on Windows 7, having now moved to Windows 10 if i chose to display the email and there is an attachment i am unable to click the send button as it is masked by duplicated, but blank, To: CC: and Subject boxes. With...