How to get Excel to send reminder emails to Outlook

Hi, i'm new here and finding a lot of VBA suggestions but i'm not familiar with using it at all(as in, i didn't know about VBA until just this week)
My manager wants me to figure out a way to have automatically-sent reminder emails/notifications from excel to outlook. More of like a "hey, just to remind you that this project is due soon!" kind of thing, nothing too intricate/personalized. I figured out how to import excel to a new calendar in outlook but this wasn't what my manager was looking for; he's insistent on the email
My manager isn't too keyboard-savvy, and i don't know if he's going to want to learn VBA to do a seemingly-simple thing..is this possible/can anyone help?
Thanks in advance!

Thank you for taking the time to reply!
Right now, i'm using an Excel 2013 to track products, the shipping date is the due date, and there is a column that includes the person who made changes to the product last..i'm sure i can add fields like "email", "reminder sent", etc but i have 700 rows to work with and i don't know much more about this assignment as i'm an intern and was just handed this worksheet to figure out.
Let me know if you need anymore information, and thanks again for your help!

Oh ok, i really appreciate the help though..
I don't think i can share specifics, but say the columns are:
col A=product name
col C=due dates(reminder email~1 week before this date)
col F=email
If there's a macro or an "IF" function that could do the job, i think those are easier to teach than how VBA works..i know how to make a macro, and i'm sure my boss wouldn't have too much trouble with a formula or two, but writing VBA is just not in our skillset. But if VB is the only way to do it, then it is what it is-my boss just REALLY thinks there's a way around it, is all..
Sorry, i'm a difficult one.

Hi Bluewitch,

I use the following code,

Please Login or Register  to view this content.

feel free to amend it to suit your needs

Well, i've been trying to troubleshoot a few errors using GeneralDisarray's code, but i can't seem to figure this one out:
"Run-Time Error 91: Object variable or With block variable not set"
This is what the code looks like:


Option Explicit
Sub Macro1()
Dim msOutApp As Outlook.Application
Dim msOutMail As Outlook.MailItem

Dim myDueDates As Range, c As Range, myTasks As Range

Set msOutApp = New Outlook.Application
Set myDueDates = myTasks.Range("B2:B" & myTasks.Cells(Rows.Count, 2).End(xlUp).Row) <---highlighted row

For Each c In myDueDates
On Error Resume Next
If (c.Value - Now()) < 14 Then

Set msOutMail = msOutApp.CreateItem(olMailItem)

With msOutMail
.To = c.Offset(0, 1).Value
'.CC = ""
'.BCC = ""
.Subject = "Reminder " & c.Offset(0, -1).Value
.Body = "Reminder " & c.Offset(0, -1).Value & " is due on " & c.Value & ". Please git er done!"

'.Display
.Send 'sends the mail item
End With

Set msOutMail = Nothing

End If
Next c
End Sub


Sorry, i just copy/pasted it; i don't know how you two put the code in its own box
@nickhunt: thank you for your suggestion! I (think) i saw this one on youtube, and suggested it to my boss, but he wants reminders emailed out and not color-filled because he wants to avoid looking at the spreadsheet to see what's upcoming/past due. :l