Hello! The code is not available, is that right? We have to purchase the course?

Your first 17 seconds showed what i was looking for - many thanks mate

Excel file is not downloading i need code to practice please send me the files if possible

I'm not getting the default signature. How can one add it?

I'm very glad I could help :)

Hello bro, same here. I also have to add tables for daily orders in my mail. Did you figure it out how to add? If yes, please let me know

@@shubhamgond11 Yes, you can add only selective content from the sheet instead of sharing the complete sheet

Here's another way to do this without any VBA and only using a few formulas! kzfaq.info/get/bejne/jah4ftuLur_SY2g.html

Refer to Leila gharani’s video where she talks about this

:)

Can you send the code for this.

@@petersonmcdavid5520 The code below sends a PDF that is generated in another macro to a list of recipients. The list is generated from a form with a dropdown box that allows you to select multiple recipients. That dropdown box is on a master form and the names and emails are stored on a separate Worksheet within the workbook. Once the names are selected the macro I provided below is executed. It runs through a loop For/Next and for each name selected it executes the send routine imbedded in this code. I admit this is not as clean as it could be but it worked for my purposes. I just tested it and it still works. Hope this helps. Kevin Private Sub Email_PDF_Click() Dim emailapplication As Object Dim emailitem As Object Dim membername As String Dim membmail As Variant Dim ML As Worksheet Dim count As Integer Dim i1 As Integer Dim NoEmailCount As Integer Dim printnoemail As String Dim DS As Worksheet Dim listcounter As Integer Dim meetingname As String Dim i As Integer Dim group_name As Integer Dim PDF_Email_File As String Set emailapplication = CreateObject("Outlook.Application") Set emailitem = emailapplication.CreateItem(0) Set ML = Worksheets("Member List") Set DS = Worksheets("Data Sheet") count = WorksheetFunction.CountA(ML.Range("A:A")) - 1 meetingname = DS.Range("G2") Module2.Create_List_PDF NoEmailCount = 2 PDF_Email_File = ActiveWorkbook.Path & "\" & meetingname & " Membership List.pdf" listcounter = Edit_List.Listcount For i = 0 To listcounter - 1 If Edit_List.Selected(i) = True Then membername = Edit_List.List(i, 0) membmail = Edit_List.List(i, 1) If membmail = "" Then GoTo errorloop End If emailitem.To = membmail emailitem.Subject = meetingname & " Meeting Lottery" emailitem.Body = membername & ", the latest version of the " & meetingname & " Member Phone List is attached." emailitem.Attachments.Add PDF_Email_File emailitem.send Set emailitem = emailapplication.CreateItem(0) errorloop: End If Next i Set emailitem = Nothing Set emailapplication = Nothing Worksheets("Front").Select Range("a1").Select For i = 0 To Edit_List.Listcount - 1 Edit_List.Selected(i) = False Next i End Sub

@@kevinklarnet8115 I love it are you currently on LinkedIn?

@@petersonmcdavid5520 Glad it helped. Took some time to cobble it together a while ago. There may be a couple of unnecessay lines of code there. Yes, I am on LinkedIn.

Thanks RS, I'm glad you think so :)

You can create (Regards and Name )the signature on the mail body while writing the code or you can use the signature as a reference also.

Same here

What was working for me was setting scheduled notification in Outlook which triggered sending email. Or you can set Windows schedule item which triggers excel sheet with VBA executed while open.

Thank you! I'm glad you liked it!)

Thank you! :) Subscribe to the weekly newsletter on TeachExcel.com and you will be always informed, including for the new classes I am making)

Yes

Glad to help)

You're welcome! Glad to help)

%OA is equiv of carriage return/ new line, insert in your text, spaces not required before or after so "have a nice day%OATim" puts on two lines

No, but you can create code that does all of that in the background - creating the workbook, sending it to the user, and deleting it - for each user. If you want help figuring this out, post your question in our forum and provide a detailed description of the issue and any code that you are already working with. The solution to your issue is not complex, but it requires a few lines of code for sure. The forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment

How did you do that? I have an excel file with 2K email addresses that I need to send out with an attachment. rock.michaelc@gmail.com

Configure your Gmail on Outlook and then you are good to go

Hi Michael, first, save the file before sending it and then you can control its name.

I'm so happy to hear this :))

Did you get the solution bro?

Basically, you can do anything you want with the macro, but I do not have a video or tutorial specific to your need. Check some VBA/Macro tutorials that mention looking up data and using IF statements to check the data and using the FIND method in vba and combine that with, probably, using a placeholder in the body of the email that you use to replace with the name - if you keep the email body in the VBA code in Excel.