automatic emails based on excel circumstances

Hi, i've researched my question, asked a different forum about it, but i need a way for Excel to automatically send emails in outlook based on due dates(reminder emails) in Excel. But i can't write VBA, and i'd have to teach my boss how to do this without it. Just wondering if there is a way to do this, maybe with a macro? So for ex: col A is the item, col C is due dates(i need a reminder email sent when [to]day is a week before the due date), emails are in column F. The reminder is just about when the product is due for shipping, to have it ready, etc. Maybe if there's an "IF" function? I'm totally stumped.
Thanks in advance for any help, tips!
bluewitchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Thomas Zucker-ScharffSolution GuideCommented:
I'm not great with vba but I received a lot of help writing this script to automate emails to outlook based on fields in excel. Some of this is relevant (like how to address outlook from vba, and how to bypass the safety in outlook), and other parts are not. I'll help if I cam and you are free to use what ever you wish.

http://www.experts-exchange.com/articles/17839/Mailmerge-using-Visual-Basic-MS-Excel-2010-and-MS-Outlook-2010.html
1
Thomas Zucker-ScharffSolution GuideCommented:
If you want the excel wkbk let me know
0
Thomas Zucker-ScharffSolution GuideCommented:
Here is the workbook - it is an xlsm file so it includes macros/vba.
generic-email.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Thomas Zucker-ScharffSolution GuideCommented:
I looked this up and you can use this code to create a simple if statement based on a cell value:

Dim score As Integer, result As String
score = Range("A1").Value

If score >= 60 Then result = "pass"

Range("B1").Value = result

Open in new window


The full if, then, else statement info is at:

http://www.excel-easy.com/vba/if-then-statement.html
0
psteffCommented:
Not sure what you want for sure, but if you want to manually invoke a macro/vba once a week or once per month to send out "delayed" emails (emails that are ready to send waiting in Outlook, but won't send until the right day), then something like the following code shows the ".DeferredDeliveryTime" portion of it within the "With OutMail".  You would then need to set up a column within your worksheet for the date and time that you want the email to be sent and then automatically reference it using vba.

Some caveats: if your local Outlook is not up on the day that the reminder should be sent, it will not send.  Also, if the reminder would happen to be on a weekend, I think it will send out the delayed email the next time your Outlook is open.  I think I have tried this and that is how it operates, but you would want to check that out yourself.

With OutMail
        .To = "anyone@anycompany.com"
        .Subject = "DeferredDeliveryTrial" & "Delayed Delivery - New Way"
        .HTMLBody = "Trial of a Deferred Delivery"
        .DeferredDeliveryTime = defertime
        .Send
    End With
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.