Send email with attachments from a list 🤓😎: kzfaq.info/get/bejne/bc-diMZhvs7KhmQ.html

Watched a lot of videos but this one actually helped, thank you Sir!

Brilliant! This worked out smoothly! Thank you very much!

Thank you, this was fantastic.

Just what I needed - thank you.

Just what I was looking for!

I was about to buy that $50 app so I could add attachments to mail merge, you saved me!

Great job. Thanks buddy.

Great thanks Greg!

Thank you 🙏🏼

Thanks for sharing! :D

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)

Thank you so much!!! 🙇

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?

thanks for the video ☺

thanks a lot!!

Thank you for the video. in this case how to include the code to save the outlook draft email into local folder 1st?

super brother

Hi Greg, this is wonderful however my attachments and body of the email is not displayed. Anything that you can suggest why that's happening?

Hi Greg, Can I link .to and .Attachements.Add to a cell value? If yes how that can be achieved?

Can you use attachments.add with a file path that is specified by a file path manually entered into a certain cell?

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

Hi Greg, Your lesson is very beneficial. Can I automatically convert the report from excel to pdf and send.

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?

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.

I am getting stuck at the .Display portion of the VBA. Any suggestions on what might be causing this?

Hi Greg, Amazing video-lesson. Is it possible to attach the active sheet (not whole book)?

Hello, I want to export the selected area as jpeg or png in Excel. Can you help me. Thank you.

How do you do it without saving the document? I have a read only form that I would like users to prefill and send but not replace original form

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.

Are you able to attach a file based on a variable? (i.e. If cell A2 = "North" then send the workbook North.xlsx, if A2 = South then send South.xlsx)

Hi! Can the email address be dynamic and dependent on what email is input in a cell?

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?

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

This is amazing! quick question. does anyone know how to also include a hyperlink into the email body? like for question please email back "here"

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

I want the attached file to come from a shared drive. Will the email recipient be able to directly save it to that location?

How to attach only specific sheets in Excel

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

Hi, the files are not attaching in the mail. Any idea as to the reason? Thanks,

Sir, I did step by step what you did and nothing was attached! Any idea why?

Can we attach Excel file in email and table at mailbody both at same time through Macro? If yes can you please prepare a video for same?

I want pickup the subject, to, body from excel sheet but not in range only specific cell ie sheet2 "A2"

Hi, I did everything like you did but I don't get the attachment into the email. What am i doing wrong?

Can we send by Gmail

Would loooove to know how to do this with SharePoint file paths instead of file paths for saved files🤔

How would I add in an additional email address if I wanted to send to more than one person at a time?

Is there a way to just open the path to the attachment for it to be selected?

Also include the send option within Macro

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