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
.Display
.Subject = "Subject"
.Display
.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.
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
.Display
.Subject = "Subject"
.Display
.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.