Directory Mail Merge to Email Messages?

What email program are you using?

Outlook 2007

If you have Outlook https://support.office.com/en-ca/article/Use-mail-merge-to-send-personalized-e-mail-messages-to-your-e-mail-address-list-c49e5cfc-53f9-4ec8-9bd9-1f8f3648f1b7?ui=en-US&rs=en-CA&ad=CA.

@something, if I use that method, it will send a separate email for each row in the spreadsheet. I went all rows in the spreadsheet for a particular student to be in one email to that student.

Concatenate the rows for each student into one row using http://techwelkin.com/ms-excel-how-to-use-line-break-in-formula. Or heck, just use semicolons. You can probably write a script to do it, matching on the student ID.

Mailchimp will do this for you.

If you have their email addresses in the Excel spreadsheet, you can probably do this from within Excel. Here's some macro code that sends email: Sub send_email() mail_subject = "Insert Your Subject" ' Working in Office 2000-2010 Dim rng As Range Dim OutApp As Object Dim OutMail As Object Set rng = Nothing On Error Resume Next Set a range of the information you want to print - this is specific to my app Set rng = Sheets("KT Summary").Range("report_rows_cols").SpecialCells(xlCellTypeVisible) On Error GoTo 0 If rng Is Nothing Then MsgBox "The selection is not a range or the sheet is protected" & _ vbNewLine & "please correct and try again.", vbOKOnly Exit Sub End If sendit = 1 ' ended up not using If sendit Then With Application .EnableEvents = False .ScreenUpdating = False End With Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "[email protected]" .CC = "" .BCC = "" .Subject = mail_subject .HTMLBody = RangetoHTML(rng) .Send End With On Error GoTo 0 With Application .EnableEvents = True .ScreenUpdating = True End With Set OutMail = Nothing Set OutApp = Nothing End If ' sendit End Sub

@brainmouse, I don't think I know how to concatenate only those rows that match a specific ID number. It might be 3 rows for one student and 5 rows for another student. @Nevin, I think MailChimp might work for us, but we have 2500 students at our school. I would have to pay for it, right? @achrise, I like the idea of your code, but after studying it for a while, I'm not sure I understand where I would change the code to fit my data. So, where do I tell the code that the email addresses are in column D? And how does it know to include all rows that have a matching ID number?

My code would be included in a loop that goes through your people one-by-one. Looking back I'd probably move some things around (specifically defining the range AFTER the On Error. You'd start your loop after the On Error (after everything is defined), and within the loop you'd step through your people, defining for each the range (which is the message that gets emailed) and the .To address. then end the loop after the End With and before the On Error Goto 0. Taking another step back, you might want to have a separate sheet with a format laid out where you could poke each person's schedule into. Then you could define the range once to be the nice formatted area, do all the Dims and Sets and enter your "people" loop. Then take each person's individual information and poke that into the nice formatted sheet and mail that. repeat until done.