outlookapp

  1. N

    VBA copy visible cells to email body below text

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

    Send Attachment via E-mail (extra)

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

    Error file path in not correct while attaching in email

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

    How to have Attachments based on a cell value VBA.

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

    Have mail list use concatenated cell from a worksheet to populate generated email

    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()...
  6. C

    Sending email with hyperlink to file

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

    save in PDF and SEND the same by outlook

    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:= _...
  8. D

    Email to Multiple Recipients with attachment

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

    Bypass Outlook Security Popup

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

    VBA works in Excel 2013 but not Excel 2010

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

    Trying to get Excel to send a sheet as a PDF

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

    VBA to loop through rows sending email

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

    open multiple blank emails with vba

    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()...
  14. G

    Cant click on email send button with attachment added

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top