Automatic Outlook mail due date reminder based on Excel file

**iamitp** · 07-08-2014, 02:15 AM

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks

**humdingaling** · 07-08-2014, 03:03 AM

i've put a check cell in column F so you do not repeat reminders

Please Login or Register  to view this content.

**iamitp** · 07-08-2014, 03:16 AM

Thanks a lot humdingaling! It works like a charm!

Can you please help me modify the code so that the mail is sent (instead of opening the mail window).

Amit

**humdingaling** · 07-08-2014, 03:42 AM

Please Login or Register  to view this content.

i put a ' infront of send so it doesn't send, remove it and it will send (it should be in green in the code)

likewise for display
if you dont want to look at message as well put a ' in front and the email message will not show

**humdingaling** · 07-08-2014, 03:47 AM

ps the code has been made so

Please Login or Register  to view this content.

meaning as long as the date in cell minus 7 is less than today it will trigger
which is why i put in the check cell in column F

**iamitp** · 07-08-2014, 05:28 AM

Thank you so much! Just one problem, when I remove the ' in front of send and put one in front of display and run the code, email for 1st guy ([email protected]) is fired off. But then I get the error message (image attached)excelerror.jpg 'run time error......'

**humdingaling** · 07-08-2014, 09:11 PM

try this code

Please Login or Register  to view this content.

**iamitp** · 07-09-2014, 05:26 AM

Works great!

Thanks so much! You're a genius

**humdingaling** · 07-09-2014, 08:28 AM

not a problem

please mark as solved if your question has been answered

Cheers
hum

**ranjan20** · 01-20-2015, 10:14 AM

Thats a nice solution. I used it for my purposes and tested with the same data in prignal excel.
If I need to send same email to multiple email user what should we do. Say for example [email protected] and [email protected] both should be notified with all values present in column B of excel.thanks in advance.

**humdingaling** · 01-20-2015, 07:16 PM

you really should have started a new thread, i didnt even know i was still subscribed to this thread

This line controls who you send to

Please Login or Register  to view this content.

all you need to do is modify it with ";" in between each email address

if you need help beyond this
start a new thread posting your specific question with example sheet if possible

**isurunk1** · 08-12-2017, 12:05 PM

how to trigger a email authomatically without commanding through excel by user

**protonLeah** · 08-12-2017, 03:52 PM

isurunk1,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**ABHIJITNAZIR** · 10-10-2017, 04:05 AM

Dear all
This is working but not on due date. How the mail block before due date. Please any one help in forum.

Thanks
Abhijit

**protonLeah** · 10-10-2017, 02:36 PM

ABHIJITNAZIR did you see post #13?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**pmc22222** · 12-12-2017, 07:29 PM

Very nice explained.

I am trying to make my own project of Calibration reminder. Could you help me to send Multiple emails like above.

Capture.PNG

Thanks

**bakerman2** · 12-12-2017, 08:31 PM

pmc22222, welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**AmalJS** · 08-18-2019, 05:27 AM

hi,

Everything is working fine. But i have three concerns regarding this;

1) I want to bold the cell value in the email body.
2) the code is not running automatically when i open the excel file.
3) if there are more than one entries with due dates less than 7 days then only the last one will be sent and the rest will be skipped.

Expecting your kind support

**protonLeah** · 08-18-2019, 05:51 PM

AmalJS,
Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Automatic Outlook mail due date reminder based on Excel file

LinkBack

Thread Tools

Rate This Thread

Display

Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Re: Automatic Outlook mail due date reminder based on Excel file

Thread Information

Users Browsing this Thread

Similar Threads

Birthday and work anniversary reminder from excel file to outlook email

Sending automatic reminder based on date

[SOLVED] Automatic E-Mail notifacation based on Date in cell

Send reminder mail from excel using outlook

Automatic Email Alerts based on due date in Excel Via Outlook

Bookmarks

Bookmarks

Posting Permissions