I've watched a handful of attachments.add videos and this was the first one that worked for me! My only barrier now is to figure out how to choose what file within a specific file path. (multiple emails with multiple attachments corresponding to the contact im sending it to)
This is awesome! Thanks man! Can you do a video that shows how to add the 'Check Names' inside that code in cases where you have 20+ emails in the To and CC segments in an email?
Hello Greg, Is it possible to add another section where it would be sent out via a team email instead of my own person email. How would I go about this ? Thanks for the great video btw.
Hey Greg, thanks for making this video it has been very helpful. One question: In your .HTMLBody portion you include the & .HTMLBody after the strBody. My strBody will not populate in the body of my email unless I remove this. If I remove this i do not get my signature at the end of the email unfortunately... any solution for me? Thanks
Trying to upload the activeworkbook sharepoint link as a body attachment so that users when they receive the email can be directed to the sharepoint area. Any ideas?
I am trying to create an automated system where I can email the customer statements. If I had a Pivot Table, how can I code it where it filters the Customer name based on the next loop and it then sends the table copy to the assigned email address. Let it loop to the next customer, which means it would filter the table again and sent that new table to the assigned email....etc. You made me understand the whole how to add a table to the email but If you can show a way to make my situation work, I would really really love to see it.
I'll make a video on that scenario as soon as I can! Thanks! You could combine the code/logic from this video with the one on sending a table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7Chuqz5M65U.html . Hope that helps and apologies for the late reply!
Hi Greg Thanks for this code But I am encountering a problem where the code is working fine, it even displays the mail before sending, but when I click send, it won't go to the recipient as well as there is no trail in my Sent item as well. Can you help me?
I've never heard of that before. There may be some sort of security preventing it from going through. Maybe try .Save instead of .Display or .Send and see if you can manually send it from your saved folder until you can determine what's actually blocking it. Hope that helps!
What if the attachment is dynamic, meaning i already have a macro that saves the file to be attached as a date linked to a cell within the workbook, how would i go about having it attached? Helpful vid btw..
@@greggowaffles thanks for the timely response, I tried something like that but no attachment came up so maybe i did something wrong, i tried variable path="c:\documents ew weather report -" & format(activesheet. Range(a3), "mm-dd-yyyy") & ". Xlsx", fileformat=51 which saves the file but no luck, tried it without the file format and breaking it up into separate variables with path and filename separate..
Thanks for watching! Hope this video helps: Excel VBA Macro: Send Email (with Hyperlink) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0kYmKFzMDiA.html
the recipient would have to manually save it to that location if you send the file as an attachment. if you reference the file in your email with a hyperlink, then the user will automatically be able to open and save directly to that shared drive location. apologies for the late reply
Thank you for the great video! Just what I was looking for Is it possible to choose a different mail to send from? I manage several email accounts in my outlook and would like to choose a different one automatically. ".From = " does not work for me
Go to 'Contacts', choose 'Home', and click 'New contact'. Set the name 'Undisclosed recipient' for the address you want to use for bulk emails as sender. Save your changes. Now to send email to multiple recipients you can just select created contact and add it into the 'To' box.
Thanks for the code and explanation ! I've been struggling why attachment wasn't working ... I wrote Attachement instead of Attachment ... lost few hours on this hahahahaha
Great Video, How would I send an attachment that references a cell in the active worksheet that has the file pathway instead putting it in "C:\destop eport\01.pdf ". I have the following code so far: A1= First Name B1= Last Name C1= To email address D1= CC E1= Subject F1= File Pathway Sub send_email_attachment() Dim EApp As Object Set EApp = CreateObject("Outlook.Application") Dim EItem As Object 'Dim EApp As Outlook.Application 'Set EApp = New Outlook.Application 'Dim EItem As Outlook.MailItem 'Set EItem = EApp.CreateItem(olMailItem) Dim path As String Dim RList As Range Set RList = Range("A2", Range("a2").End(xlDown)) Dim R As Range For Each R In RList Set EItem = EApp.CreateItem(0) With EItem .To = R.Offset(0, 2) .CC = R.Offset(0, 3) .Subject = R.Offset(0, 4) .Attachments.Add = R.Offset(0, 5) .Body = "Dear " & R & "," & vbNewLine & vbNewLine _ & "Please find attached your report. " & vbNewLine & vbNewLine & "Respectfully," & vbNewLine & vbNewLine & _ "signature" .display End With Next R Set EApp = Nothing Set EItem = Nothing End Sub