Auto subject,name,email,deferred


New Member
Outlook version
Outlook 2013 64 bit
Email Account
Office 365 Exchange
Hi All,

I have an excel spreadsheet with 200 names and emails. I am trying to create a macro that will be able to automatically email all 200 recipients with their name in the email and the subject line filled out. The emails will also have a deferred delivery time. Currently I do it like this:

Sub NewMessageWithAttachment()

Dim oMsg As Outlook.MailItem
Set oMsg = Application.CreateItem(olMailItem)

With oMsg
.Subject = "Subject"
.DeferredDeliveryTime = "05/28/2016 08:30:00am"

End With

End Sub

This means I have to run the macro, enter the email address and then the name at the start of the email. Does anyone know how I could write a macro for this or just a simpler way to complete this annoying task.