Computer Support Forum

Automatic Reminder email from Excel 2013 in Windows 7 pc

Question: Automatic Reminder email from Excel 2013 in Windows 7 pc

Hello Everyone!

This is my first post here. I am using Excel 2013 OS win 7. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) 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,

Relevance 100%
Preferred Solution: Automatic Reminder email from Excel 2013 in Windows 7 pc

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Automatic Reminder email from Excel 2013 in Windows 7 pc

closing duplicated post
continue here
http://forums.techguy.org/business-applications/1141421-automatic-reminder-email-excel.html

1 more replies
Relevance 101.27%

If I am doing an automatic email reminder when something is past due:

do I always have to open the Excel document for the macro to run and the reminder to sent out?

Thanks,
 

More replies
Relevance 101.27%

Hi,
I'm kinda new to VBA and excel programming and am looking for a way of sending an automated reminder 60 days before the expiry of training already completed. column G contains the email recipients, Column E has a title Asbestos Awareness and the cells in column E the expiry dates for employees.
I would appreciate if anyone has sample code I could try.


Thanks sooooooooooo much for any help or advice.
Regards
Vinny
 

Answer:Automatic Email reminder in excel

Hi Vinny,
welcome to the forum, you're the second one this week with the same question, and just like the other poster I do not think you took the time to search for similar posts.
I suggest you do hat, there are several posts with the similar questions and also with the answres and code provided.
 

1 more replies
Relevance 101.27%

Hello 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 nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) 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,
 

Answer:Automatic Reminder email from Excel

Hi, I suggest you do some searching, there are quiet a few posts with the same questions and the necessary solutions.
I worked on one or two but cannot remember the names, so just do a quick search and you'll find the answres with the necessary code.
Always to glad to help on if you're still stuck
 

1 more replies
Relevance 97.99%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

1 more replies
Relevance 82.41%

GOOD DAY, NEED YOUR KIND ASSISTANCE TO THE FORMULA I MAY FORM TO SEND REMINDER E-MAIL TO MY CLIENTS IF ONE OF THE 3 COLUMNS CONTAINING DEPOSITS DUE DATE IS WITHIN 1DAY AND NOT YET BEING PAID.THANK YOU

Answer:Excel 2013 auto sending of reminder e-mail

This cannot be achieved with a formula you will need a macro. The requirement is fairly straight forward but we need some more information to be able to produce this. How is your workbook laid out? we need to know1) which cell has the dates in it2) which cell has the email addresses to which you want the email to be sent3) what the email body and subject will be Also please note writing it caps is considered shouting, please don't type in caps.

3 more replies
Relevance 78.72%

Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k
Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.
Thank you for your support.
 

More replies
Relevance 77.9%

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
 

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

8 more replies
Relevance 77.9%

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

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

16 more replies
Relevance 77.9%

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 payment is 10 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. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

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

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

I'd really appreciate any help,
 

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

15 more replies
Relevance 75.85%

I have searched and read the topics on this, however I am apparently below beginner and need someone to walk me through the entire process. I need an email sent to myself and 2 other co-workers one day before an item listed in my spreadsheet expires. I have the expiration dates are listed in column F. I have not entered any email addresses yet.I would like, as I have read in previous threads, for the system to open and check itself daily. Any help is greatly appreciated, and I will need a very basic, step by step hand holding description.
 

Answer:Excel Email Reminder

Hi, welcome to the board.

I suggest the following link, there enough information and samples there too.

http://www.rondebruin.nl/sendmail.htm
 

2 more replies
Relevance 75.03%

Hello there,

First time posting and very average excel capabilities... Working on generating a code that will send automatic email reminders 7 days prior to the date within rows F-P. Recipients contact information is in column S.

Thanks for your time.

Tim
 

More replies
Relevance 75.03%

I have a list of task (maintainance schedule) to do... and they are required to be done in a by certain different dates regularly (eg. every 14 days or every 28 days)

I have a specific maintance date for each task within the same row. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

thanks
 

Answer:Set email reminder base on Excel

16 more replies
Relevance 75.03%

Hi guys,
I have a list of some certifications and their respective expiry dates written in Excel sheet. What I want is to be getting Auto reminder few days before, on and after the expiration date.
Attached is the VBA program that I tired to use but it was reading the whole data instead of being selective. Also attached is an extract of the excel sheet.
Pls I will appreciate any help
Thanks,
CJ
 

Answer:Auto Email reminder from Excel

Have you read the Thread under yours -
http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
 

1 more replies
Relevance 75.03%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Set email reminder based on excel

Hi, take a look at some of the posts, there are quiet a few that do just that, they may need a little editting for your purpose but...
Here's a simple module that does just that, all you need to do is wriet a amcro that fills in the blanks

Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, Sendto As String, CCto As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function


P.S. You forgot to mention the Excel versio you're using
 

1 more replies
Relevance 75.03%

I have a real simple need. Well, it's probably simple for some. I have a sheet built to track employee hire dates and eval dates. I would like to assign excel to open everyday at a time and then evaluate the cells with the eval and raise dates to see if an email needs to be sent to the supervisor. If so a simple "there are employee items coming due" email is sent to the supervisor. The super will go to the document and take care of the rest. Dta is not real. The email with the employee name isn't the one I'll be sending to. The Team Manager at the end is where the email will be going to for all on the sheet. I would appreciate the help. Running windows 7 and office 2013.
 

More replies
Relevance 74.21%

Hi everyone,

I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.

The email should look like:

To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)

Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.

<personal email signature>

Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?

Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?

And how do I change the email where those reminders will be sent from?

Any help with regards to the above would be greatly appreciated. Thank you so much.
 

Answer:Auto Email Reminder from Excel when project is almost due

16 more replies
Relevance 74.21%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 74.21%

I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.

I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED

thanks
 

Answer:Set email reminder based on conditions on Excel

10 more replies
Relevance 74.21%

This is my first time posting on here so I hope this is the right place.

I have attached a spreadsheet I will need to populate and we would like to send staff members an email reminder before they need to do their task. Maybe a day or the morning of the day is fine, as long as they get the reminder. I was just wondering how I would go about doing that?

As the Excel file would need to be opened in order to work , I was also wondering how I would be able to set it to open on the start up of everyones machine. Even if it can only start up the programme then it will be obvious to people what they need to open.

Could the email or subject include as much info as it can. Like name, company, job title and contact number. and for it to be sent to the Asignee.

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

More replies
Relevance 74.21%

Hi Guys,

I have just joined this forum, I found some solutions given by Zack quite useful to me. Thank you so much.

But also need help in taking it further, as I have created a worksheet with lots of data which will have to be incorporated while sending auto email reminders to various admin officers depending on the dates, especially for Statutary payments like Telephone, Electricity etc.

If any body can help....... Please...............
 

Answer:Auto Email reminder from Excel Sheet

http://forums.techguy.org/business-applications/773873-how-make-excel-send-email.html
 

1 more replies
Relevance 74.21%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Solved: Set email reminder base on Excel

you have another thread here
http://forums.techguy.org/business-applications/1055728-set-email-reminder-based-excel.html
please do not duplicate posts - closing this one
 

1 more replies
Relevance 73.39%

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.
 

2 more replies
Relevance 73.39%

Hi lovely people!

I hope you can help me out - I'm new to macros. In regards to the attached excel file, I need to achieve 3 main goals:
Automated pop-up message - For each phone that is overdue for delivery (ie current date is more than due date), I need a pop-up message upon opening the excel sheet. The pop-up alert should say which phone is due (stock #), and how many days overdue it is (current date minus due date)
Automated email reminders - emails to send to various email accounts (individuals in my team) to remind them of overdue phones. The email should include details like the phone, stock #, supplier, due date and how many days overdue. I want the first email reminder to be sent on the due date itself, then 2nd reminder on the next day, and subsequent reminders every 3 days.
Have a separate sheet listing all the overdue items that need to be followed-up.

Lastly, but is it at all possible to create two versions of the same stock list? I.e. one sheet in English, and the other sheet in French. And any edits in either sheet will update the other version.

Cheers!
 

Answer:Excel help! Automated pop-up box and email reminders, and reminder list

Hi, welcome to the forum.
Have you doen a search in this forum.
There are many posts that relate to triggering a mail message based on calculations and expiry dates, etc.
You will of course need to edit some solutions for your purpose, but I do suggest you take a look (search) and probably you'll find what you need.
The question about the two languages is custom macro coding and will take some time.
Your sample contains onle one row of data, but nothing more to go on.
Do some homework (searching the forum) and someone will be able to help
Please don't forget to mention the Excel version, as far as I cansee it's at least version 2007 but it could be 2010 or newer
 

1 more replies
Relevance 73.39%

hi !
I have a spread sheet of 100 of employees , i like every time the expiry date come for there id a notification email come to me , i attach the example excel sheet please help me with that, i am just learning VBA not very good in it i am using windows 8
 

More replies
Relevance 72.57%

Hello Friends,I am leading the finance team. I need to create an excel worksheet which tracks all my invoices raised on different clients alongwith the due dates. I want excel to send an auto email to client after 2 days of due date and second reminder after 7 days or so.I am from finance back ground and thus do not have any idea of running any codes or macros.Can any body help me with this on priority basis?Thanks and regards,Manish

Answer:Excel worksheet to send auto email reminder to clients

Try here:http://www.rondebruin.nl/sendmail.htmLook under the section: Add-ins and Worksheet TemplatesMIKEhttp://www.skeptic.com/

2 more replies
Relevance 67.24%

Hi Guys,

I realise that there are lots of different threads on this subject but I'm afraid none of them make sense to me as I am very much a newbie to coding in excel. I have created a spreadsheet that tracks the amount of holiday entitlement that staff have left and would like an automatic email to be sent out when this number reaches a certain level.

I have attached the file below.

I would like the email too be sent out when the number is Column G reaches 10 and again when the figure reaches 5. Ideally, I would want the same email to be sent to two or three different people at the same time, and would want the content of the email to contain a specific text, including how much holiday entitlement the employee has remaining.

If anyone could please provide me with help on this it would be massively appreciated as I am really struggling.

Kind Regards,

Gareth
 

Answer:Automatic Email in Excel

Here is the file, I always forget to attach them!
 

2 more replies
Relevance 67.24%

Hi there,

I'm new to this forum and relatively new to Excel; when I say new to Excel I mean in that I know how to do the basics like creating tables and doing some formulas to calculate totals, averages etc.

What I need to be able to do is a variation on something I've seen many examples of in that I'd like to create an automatic email that will be sent based on the choice made from a pre-defined list available via a drop-down menu.

So, it would look something like.

Column 2 contains a drop-down on each cell where the user selects the name of a course. Once that course name is selected the author of the course is populated in column 3 in the cell next to the name of the course and next to that, in column 4 is a cell that contains the e-mail address of the author.

I'd like for the author that is populated to receive an automatic email to notify them that their course has been chosen on that spreadsheet.

I have created the functionality that populates the name and email address of the author based on the drop-down list using Lookup but what I don't know how to do is trigger the email. And I need to know how to do this for multiple authors and not generate repeat emails everytime the workbook is saved - so only a new addition would trigger the email.

Can anyone help please?

Thanks.

J.
 

Answer:Automatic email in Excel.

I'm at a loss for helping but here is a group dedicated to Excel. If there's a way to make Excel tie your shoes ... they can work the formula out!
http://www.excelforum.com/
 

2 more replies
Relevance 67.24%

I am new to this so be easy with me. I am trying to have Excel (2003) send an email out 60 day prior and on the date set in the "E" column (see file attached). I would like the email to go to the email address set in column "K" and say your CSA contract with "insert company name from column "A"" is about to expire in 60 days. Then basically the same for the email that is sent on the date of expiration but to say that it is expired.
 

Answer:Automatic email from Excel

13 more replies
Relevance 67.24%

Hi All,
I am new to this sort of stuff; this is the first forum I have joined.
What I want to do is set up a worksheet in excel 2007 e.g.:
Course A
Course B
Course C
Name A
29/12/12
30/12/12
31/12/12
Name B
Name C
And 7 days before the date in a cell is due, the course name and the person’s name and the actual date will be sent to me via email automatically. Possibly, without excel even running.

I do not know if this is possible but any help would be much appreciated.
Thanks
 

Answer:Automatic Email from Excel

7 more replies
Relevance 67.24%

Hello,

I have an 2007 excel workbook that automatically pulls data from the web at certain internals and converts it into a calculation, which predicts whether various sporting events will be Over or Under a certain total. I am hoping that someone could help me to setup an automatic email at intervals of 1 minute for the five minutes before a game starts.(game start time is in the worksheet Column B). I have been reading through other posts, which basically tell me that this is possible, but I have no knowledge of how to adjust the code in order to get it to work with my file.

I would use ClickYes and Outlook. If I could get an automatic email that pasted the values and formats for the ‘Calc’ Workbook (Cells B2 – L51) and sent it to me every time a game was within 5 minutes of starting that would be awesome. If it is easier, I could just have the file sent to me every 1 minute whenever I have it open rather than just before the game starts.

I also could have the event triggered based on whether Column K has a value of “UNDER” or “OVER”

I could adjust the file in any way that is helpful, please just let me know.

This is where I found the information about the possibility of doing this:

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html

Thank you so much in advance for your help
Colin
 

Answer:Automatic Email from Excel

Hi, welcome to the forum.
Looks like a nice challenge.
I'll see what I can come up with (after checking out Zack's code)
 

2 more replies
Relevance 66.42%

Hello there,

I am pretty new to excel overall and facing a problem currently by setting up an automated process sending emails via Excel to Outlook.

*What*: I need to send out multiple cell values (which are calculated by formulas) on a weekly basis to 25 people.

Is there any (easy) automated process I could use? I've read online about using macros, but I am quite unfamiliar with that process.

I appreciate your help with this!

Thank you and best,

Regina
 

More replies
Relevance 66.42%

Hi All,

Let me take the pleasure to introduce myself as Vasu, beginner in this forum.

I know that there are many on going threads related to my this new thread. But, actually I had gone through some of the posts (like Rollin, OBP, and Diego) as per my need and I did saw OBP used to share some links which already covers this my new thread, but since I am totally beginner to MS Excel, so I could not understand many of the things. So, with left chance I thought initiating the new thread, so that I can aware of step-by-step to "automatically send an email from excel on date basis". Hope you all fine with this.

So, here is what I need, I have a sheet (which contains columns Request No, Owner, Run Date, Due Date to Close Request). Usually sometimes we miss to close the requests as per the due dates.

So, could you please share detailed information on how can my excel automatically send an email whenever the "Run Date" crosses??

As per my understanding after reading the existing posts, I thought of giving you some sample data from my side. In my attached workbook, there are two sheets ("Request Tracker" and "Email"). "Request Tracker" sheet contains the base data on which "Email" sheet contains what I need in my email when excel send an email.

I would be more than happy to give you any additional information if required.

I use MS Outlook and MS Excel on Windows.

Thanks for your assistance and help to get my problem ... Read more

Answer:How to send an automatic email from excel?

15 more replies
Relevance 66.42%

Hi There

I would like to set up an automatic email reminder for the attached workbook

I would like an email reminder to be sent 1 year prior to the expiry date in (COL F) then 3 months prior and then again when due
I would like to send the reminder to my own and potentially multiple emails.

To set up a macro as such would the programme and said file need to be open. every time the computer starts up?
 

More replies
Relevance 66.42%

Hi Everyone,
my name is steve and this is my first post. I have been asked to compile a system to recall calibrated items within the company i work for, I must stress tht my expierience with excel is very limited.
Attached is the system so far (It is the work of many butchered examples off the net, and several people who know a little at work).
I am trying to achieve a solution that when an item comes within three months of its expiry date the date column turns yellow, when 30 days or uner it turns red (Possibly gets transfere to another sheet)and then emails a short mail incluing cells B,C,D an L of that row to the "Area Owner" . I'm using office 2007, anyone think this is possible? or better still help me with this problem.
I would appreciate it so very much!

By the way, the password is ; Kalibratedbyme (capital K)
Regards,
Steve
 

Answer:Solved: Excel automatic email

14 more replies
Relevance 66.42%

Hi,

I am trying to help a co-worker automate her email notification to employees who have not followed correct procedures on their expense reports. She has an Excel spreadsheet with the name and email address for each employee, along with 10 columns to represent the type of violation. I have attached a sample of the spreadsheet, where an 'X' indicates the nature of the problem. She would like to be able to run a macro to automatically send an email to each person with an 'X' in any of the columns. In the text of the email, it would indicate the month (from column C) and the type of problem based on the column header.

For example, based on the attached sample file, John Smith would receive an email as follows:

Hello,

Your September expense report was submitted with the following errors:

Blank GL Codes
Missing or Incomplete Description
Please correct the errors and resubmit this expense report.

Thank you,
Susan Larson

I'm an accountant who has done some automation using macros in Excel and Access, but I'm not sure which application would be best for this situation. If it would be easier, I can set this up in Access, but I would prefer Excel since my co-worker has more experience with spreadsheets than databases.

I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to ... Read more

Answer:Automatic Email from Excel List

12 more replies
Relevance 66.42%

I am using MS Excel 2007. I need to send email to the departments linked to the worksheet automatically on the date mentioned as a reminder how can I do it. For E.g
I have Activity on B4 and the date of reminder on C4. I need to send a reminder mail to the concern person who would be performing the activity.How can I do so.
Note: I am not using MS Outlook.
 

Answer:Automatic Email Alerts using Excel

Anurodh, welcome to the Forum.
Have a look at the Business Applications Forum and use the search function to look for Excel email, there are quite a few Threads on there on that topic.
 

3 more replies
Relevance 66.42%

Hi all,

First post so please be patient! I've got quite a simple worksheet that tracks when the MOT, Road Tax and Services are due on our fleet of vans. I have windows task scheduler emailing this report out each week to all of staff. The problem i'm having is that as the data rarely changes these emails are ignored. I found the below post asking for something similar, with more conditions regarding buying stock.

I have mine set up with some basic conditional formatting changing the cell to yellow if the cell >=today()-30 and red if the cell >=today()-7. Now this is set up for MOT, Road Tax and Service. So ideally what i would want/need is for an automated email to say "Registration - MOT due in 30days" or "Registration - MOT due in 7days" and a similar process for the road tax or service intervals.

Now from reading the post below i'm aware that changing the cell colour doesn't suffice as a trigger so i have some cells that now string together the above sentences in hope this simplifies things. So now if Cell F,G or H change i would like an email alert to tell me what the text is in those cells. However once we have MOT'd, Taxed or Serviced the vehicle and change cells C, D or E this will change the text in F,G or H to blank. If this happens i don't want an email sending as it would be blank.

I'm running Windows 7 and Excel 2007. I have attached my current work sheet.

Any help would be hugely appreciated.

Th... Read more

Answer:Automatic Email Alerts - Excel

7 more replies
Relevance 66.42%

Hi everyone!

I would like to ask you help in developing an excel macro that is able to:

Sending automated emails if certain conditions are met. (due date approaching, passed)

I have seen a few post in the topic but i was not able to implement the code both because of my limited VBA experience and also because of the differences in my table.

There should be a total of 4 emails to be send depending on the current day (1 mail before due and 3 mails after due ) Moreover, the very last mail should be sent to a different address than the previous three.

It would be also important to being able to automatically 'reset' the system if a new action date is activated so next time when any of the conditions are applied the mails can go out again.

I was struggling to solve the issue of sending duplicate messages, as the macro would run every single day so
i like to avoid sending the same mail for more than once.

The tip of the ice-bird would be to send the mails with (gmail) smtp in order to keep one "from" mail address all the time. (multiple people would use the file). Nevertheless, we would be more than happy to use it with outlook as well if the smtp would make the code unreasonably more complex...

I uploaded my rudimentary file in which I started this, however I am afraid that it is not the proper way, therefore I uploaded an other file as well, in which it is more clear what the tool would be all about.

Thank you very much in advance if you could hel... Read more

More replies
Relevance 65.6%

Hello guys, I need some help. I have an Excel spreadsheet that I use to watch financial information about companies that I buy stocks from when certain conditions are met. I use a program called XLQ which works along with Excel to extract the financial information from the internet and displays it on the spreadsheet. The numbers constantly change based on the stock market movement. I have two conditions that need to be met in order for me to buy a stock, when such conditions are met the cells change color, I have set it up that way to let me know when it is time to buy a stock.

So my question is... Is it possible to have Microsoft Excel automatically send me an email to my email inbox or cell phone when those two conditions are met and the cells change color. I would really appreciate any help with this. Let me know if you need more details about this problem I am having.

Thanks,

Eleazar Botello

 

Answer:Solved: Automatic Email Alerts using Excel

16 more replies
Relevance 65.6%

Hello,

This is my first post here. I have been searching all over the internet trying to find an answer to my excel problem. I am pretty new to excel and my goal is to have excel automatically send an email out to me when the due date of a training is approaching. I have already set it up using conditional formatting to fill the due date box yellow if a due date is less than 30 days away but I would like excel to email me a reminder so I don't have to remember to check the spreadsheet every month.

I have it set up with a training summary sheet that shows the # of trainings due within 30 days so what I really need is a macro to send if the cell is greater than 0.

I have done a lot of searching but am new to excel programming and can not figure out how to adapt the codes I have seen to satisfy my needs. Or where to enter them

I attached the workbook I am trying to do this for. Im looking to apply the macro to the 'Training Summary' sheet.

Any help would be greatly appreciated.

Thanks,
Brandon
 

Answer:Automatic Email From Excel When Due Date Is Approaching

Hi,

In order to do this we need more information.
Will the workbook be opened every day?
If so you can set the code to check the date and E-Mail you.
If the workbook will not be opened every day then you can use the "Task" manager
and have it open the workbook to check the date.
You can also set a code than when the workbook is opened it will check the
Date and if you need to review it will activate the sheet and then Highlight the Date.
 

3 more replies
Relevance 65.6%

Hi,
I am at a company where items get checked in and out. Nothing has an exact due date but people report when they expect to have their item returned. I would like to notify these people by email:
1. When their item is within seven days of the expected due date
2. When it is past their expected due date

I have Microsoft Office for email so I know it is possible to send an email everytime the document is opened, but I'm lacking a bit in the coding field.

I have attached an example file. Any help would be appreciated.
 

Answer:Solved: Automatic Email Notification from Excel

16 more replies
Relevance 65.6%

Hey all
I am having a problem trying to send automated messages from the below excel file using the date column
all i need is the sheet to send an email alert a day before the dates mentioned in all the sheets in the workbook

Thanks in advance
 

Answer:Automatic Email using the date on the excel sheet

Hi,

See if this site helps.

http://www.rondebruin.nl/win/section1.htm
 

1 more replies
Relevance 65.6%

This site is amazingly helpful. The post http://forums.techguy.org/business-applications/954888-automatic-email-excel-list.html worked perfectly on the first attempt, it didn't require a single bit of code change.

My question is this, how would I instead of emailing the header where there is an X email the specific data that is in the cell where the X would be found along with the header? Also, is it possible to specify recipients based on the Month? For instance, I only want to email those for September.

Missing Receipts - 0
Blank GL Codes - 3
Missing or Incomplete Description - 2

I made a small change to the original spreadsheet as a reference.

Thank you very much!
 

Answer:Automatic Email Excel List part 2

Hi, welcome to the forum.
I edited your file so that you can make a choice of what you want to mail
ALL months or just one specific month
I don't understand about the Header, I see it but what is the 'Specific Data' you mention? There is nothing there it's just an X or do you mean other data?
 

3 more replies
Relevance 65.6%

Hi everyone

I hope all are fine and reading my message in the best of their health.. I am stuck with a job to do on various dates where i have to email those candidates whome progress reports are due, which due dates are mentioned in the sheet.

Can some body please help me to come up with a excel automatic mail solution that an email should be generated via outlook without opening the file or even if needed opening the file. The email should contain

Dear Student

Your progress report / proposal defense is due on (due date),

regards,
this email should be generated and sent before one month and one copy on the date on which it is due.. the cc list also needed to be grabbed from somewhere, where cc of this email should go.

I shall be very thankful if somebody can look the attached file and help
 

Answer:Solved: Excel Automatic Email on due date

16 more replies
Relevance 65.19%

Hello,

I will be grateful if you can please help me have automation in the attached Excel sheet for automatically generating and sending (triggering) Emails to the action owners based on their Email IDs upon approaching of "Actual Finish Date (column I) in the attached Excel sheet? My request is similar to https://forums.techguy.org/threads/excel-sending-automatic-email-to-owners-near-due-dates.1171902/.

You are welcome to suggest and implement value additions.

It will be a boon if this task can be accomplished irrespective of any Email client. Be it Microsoft Outlook or Lotus Notes. Please help.

Regards,
Maitreya Barve.
 

More replies
Relevance 65.19%

Hi All..
I am new to this forum. I need help related to my excel sheet designed to remind my marketing team on their scheduled reminders that have not been updated till TODAY. I want that this code runs once a day and send email seperately to all marketing teams for the customers being dealt by them whose followup needs to be updated. For example if I have two marketing boys Vishal & ishant then Vishal gets email for the customers that are dealt by him and whose followup date is either on or before today. Similary the other marketing guy also gets email. Preferably if the mail can contain subject as " Vishal Followups for 01.12.14"

I am not knowledgable regarding coding but can handle stuff at my computer otherwise. I am attaching a copy of excel file for better understanding. Thanks a lot guys in advance.
BTW my default mail client is Outlook.

regards,

panx.
 

Answer:Solved: Automatic Email from Excel after sorting data

16 more replies
Relevance 65.19%

This is prasanna from india. i need a help in my company i want to trigger mail automatically based on the date.. its kind of probation tracking mail... Example :- IF an employee has completed three months automatically mail should trigger to concern person.. is it possible in excelThanks in advance

Answer:Sending automatic Email based on the date in row in excel

Look here:http://www.rondebruin.nl/sendmail.htmYou should be able to find something you can work with.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 65.19%

I have a personnel tracker that tracks required documents that need to be renewed every year. There are 4 of these and each has a seperate column for each date. They are J,L,T and U.

I would like excel to scan each of these columns every time the document is opened for any of those dates that are 60-65 days from expiring, I use Now()-300 to check this.

But if the cell is blank I want it ignored, which right now it does not. If it finds 1 or even 80 that are in that range I want 1 email generated to a list of management personnel.

Currently it generates how ever many are blank or expiring. I use outlook.

My data starts on row 3 and goes down to 331, the required and maximum number of people allowed on the contract.

If I can get just one email with a generic message I would be happy. But if I could I would like the info that is actually doing the triggering to be copied and pasted in the email to include the info in A, C and D.

Here is my current code, I would change .display to .send once I have it working. please help.

Private Sub Workbook_Open()
Dim Cell As Range
Dim DateRng As Range
Dim Msg As String
Dim olApp As Object
Dim olEmail As Object
Dim RngEnd As Range
Dim Wks As Worksheet

Set Wks = Worksheets("Work Site Info")

Set DateRng = Wks.Range("J3")
Set RngEnd = Wks.Range("J331")
Set DateRng = IIf(RngEnd.Row < DateRng.Row, DateRng, Wks.Range(DateRng, RngEnd))

'Change this to what you want.
Msg = "This is message is the bo... Read more

Answer:Solved: Automatic email from excel based on date

16 more replies
Relevance 65.19%

Hi All,
i have seen some fantastic success in the previous thread, "Automatic Email Alerts using Excel".... But i cant seem to work it out all by myself... its doing exactly what i want it to do as described in the thread, but ive had no luck in my own sheets.
Could someone please make a blank workbook, that sends an email with the contents of A1 if A1 is not empty for example...
This would be a huge help to myself, and many others as there seems to be many threads but no cut and dry solution for a humble newbie!
Best regards,
Westy
 

Answer:Solved: Automatic Email Alerts using Excel - Please Revisit!

sorry, should have mentioned, this is for excel 2003. outlook 2003, win xp, and have clickyes file installed thanks!!
 

3 more replies
Relevance 65.19%

I have read reviews on forum on same . But still could not find a soultion probably becoz i am not savy with excel . We are basically in to procurement of material . Currently the problem we are facing is that we are not able to track ,whethe the credit period of the supplier has finished and we have paid him or not ? From best of my excel knowledge i was able to establish a formula for same and was sucessful too .i was getting information on Gap b/w payment date and todays date .Moreover I got visual indicator for same , by conditional formatting . Now my boss wants me to make a provision in the excel sheet that once teh payment date has expired , he should keep on getting reminder for same as outlook message with suppliers name and order detail . I have tried alot for same on base of information given on the forum and infact downloaded and installed Click yes active. ver1.2 too Since i dont know VB so i am not able to solve thsi problem. Can any one help me on ths issue as it is important for my promotion .The file is ready for me and can be uploaded on request .
 

Answer:Automatic Email Alerts for conditions in excel cell

9 more replies
Relevance 65.19%

Basically, I have created a very simple Excel spreadsheet as an example, but what I would like to do is the following:

I have several employees (100 +/-) that require training in various fields. Each training certification is good for 1-yr. I am trying to figure a way for Excel to automatically send an email to my Microsoft Outlook whenever that training date is set to expire. I would like to have it email me 30-days before it expires. The problem is that I don't record and notate it by the date the training expires, but rather by the date they were trained. An example would be that I trained someone on 5-3-13 and they will be expiring 30-days from now. I have it entered on the spreadsheet as 5-3-13. How can I make Excel automatically generate an email warning me of the upcoming expiration date? I am admittedly not very proficient in computer language, but I am more than willing to learn.
 

Answer:Trying to send automatic email notification from Excel 2010

6 more replies
Relevance 65.19%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-a...s-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email from Excel based on Date in Cell

16 more replies
Relevance 65.19%

Hi, I have a risk register which has action by dates for owners of that particular risk. I would like to set up a VBA code that automatically sends each owner an email reminder, through outlook, 5 days before the action date. One owner may have multiple risks due on the same date so I would like the code to send 1 email detailing all the item numbers that the owner has to look at (however this is not at the top of my requirements if it causes issues). I would like the email to include the "Number" (Col. A) in the body listing which risks the owner should look at along with a message reminding them that the action by date is near. Also i want this to be automated, I want the code to run once and send emails as time goes on. Also i will need to change the action by dates as new information is available, can the code account for this change and send another email when the new action by date is near? Thanks for your help I really appreciate it. Using excel 2010
 

Answer:Excel sending automatic email to owners near due dates

12 more replies
Relevance 65.19%

For the past 4 to 5 months I have been using the attached spreadsheet that I created to send out email notifications manual. I would open the spreadsheet daily and send the appropriate email, by clicking on the button, when the due date condition was red. This has been working great so far. Now I would like to be able to send these emails automatically instead of spending time looking through the spreadsheet to find the notices that are due and avoid missing ones also.
I realize that the worksheet must be open to accomplish this automatic send but this is not a problem since I use this spreadsheet almost daily.
I need help in making his spreadsheet as automatic email friendly as possible.

Using – Excel 2007 & Outlook

Thanks in advance.

McN
 

More replies
Relevance 64.37%

Windows 7 Excel 2010
I have a spread sheet that has entries containing email addresses. When I select one of these cells, Outlook automatically opens a new email with the email address in the TO field. How do I prevent this from happening? Earlier research suggested an option
on the Tools menu, but, of course, there is no Tools menu.
P.S. I selected the Archive Forum Category only because there isn't a forum in the list for Office, which seems odd.

More replies
Relevance 64.37%

Hi, I am really new to excel so I am hoping to get some help here. I have searched through the forum and tried several codes, but I was not able to run it successfully.

Basically in my excel file, i have a long list of documents with their respective expiry dates. I want excel to send me an email when it is 6 months before the expiry date.

I have uploaded a sample file on what my worksheet will look like.
I am using Microsoft Excel 2010.

Thanks!
 

More replies
Relevance 63.96%

one of the users running windows 7 and excel 2013 (32bit) is having issue when working on large excel files (around 50mb usually). in the middle of editing it, excel will stop responding and then go to the white screen. no matter how long user waits, program never comes back. you have to close the program and re open it to get it to respond. everything else on the computer works great and the user doesn't have any odd add-ins or anything. the laptop is an i7 with 16gb ram. should i install 64bit since the files are so large? would that help? any troubleshooting tips?
 

Answer:Windows 7, Excel 2013 (32bit), freezing to white screen when working with large excel

The 64 bit version is for spreadsheets larger than 2GB. I would make sure you have all of the latest Office patches.
 

6 more replies
Relevance 61.5%

I have set windows update to update manually, however every time I turn on, I get a little yellow speech bubble reminding me that automatic updates are turned off and that my computer might be at risk. I know that they are turned off! Is there a way to stop this reminder popping up every time I turn on?

(It's nice to get the little things right...)

I would be glad of some help.

----------
Windows XP Pro SP2.
 

Answer:How to stop "automatic windows update" reminder.

Start > Settings > Control Panel > Security Settings .... " Change the way Security Center alerts me"
 

3 more replies
Relevance 61.09%

This is a problem I have put off for a while because I couldn't find a solution anywhere on the net! Had to get by with the Auto Updates option turned off.

It's the popup we are all too familiar with:
"Updating your computer is almost complete. You must restart your computer for the updates to take effect."

The problem I'm having is that a simple restart doesn't work! I've rebooted over 5 times to no avail.
I suspect this was caused by my removing of a security update several months ago (though I can't recall why I needed to remove it or which specific update this was).

My O.S is Microsoft Windows XP Professional 5.1.2600 and I'm using Service Pack 2.
Any other information required, I should be able to retrieve.

Help will be much appreciated!
 

Answer:Automatic Updates reminder! Help needed!

10 more replies
Relevance 60.27%

Hi everyone,
This is my first query on this forum.
I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts.
The details of the input sheet are as shown below:
Col. A 'Sl. no.',
Col. B 'Vendor name',
Col. C 'Effective Date', (mm/dd/yyyy)
Col. D 'expiration Date', (mm/dd/yyyy)
Col. E 'e-mail',
Col. F 'Reminder'

As shown above, a reminder mail should be sent 14 days before the expiry date "Col. D" with the
E-mail message "Your Contract with <Vendor Name> expires on <Expiry date>. Please initiate formalities for renewal of this contract".
This mail would have to be sent to be sent to 15-20 E-mail IDs in Col. E. With the above-mentioned message. Also, once the reminder mail is sent the, the timestamp of that action should appear in Col. F 'Reminder'.
Sample input sheet has been attached.

I'm a beginner at macros and VB, any help would be highly appreciated.

Thank you,
Adman
 

More replies
Relevance 60.27%

Hi everyone,
This is my first query on this forum.
I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts.
The details of the input sheet are as shown below:
Col. A 'Sl. no.',
Col. B 'Vendor name',
Col. C 'Effective Date', (mm/dd/yyyy)
Col. D 'expiration Date', (mm/dd/yyyy)
Col. E 'e-mail',
Col. F 'Reminder'

As shown above, a reminder mail should be sent 14 days before the expiry date "Col. D" with the
E-mail message "Your Contract with <Vendor Name> expires on <Expiry date>. Please initiate formalities for renewal of this contract".
This mail would have to be sent to be sent to 15-20 E-mail IDs in Col. E. With the above-mentioned message. Also, once the reminder mail is sent the, the timestamp of that action should appear in Col. F 'Reminder'.
Sample input sheet has been attached.

I'm a beginner at macros and VB, any help would be highly appreciated.

Thank you,
Adman
 

More replies
Relevance 60.27%

This friend's computer has this icon in the lower right hand corner, a sort of shield, which keeps prompting her to update programs and so on. It's a nuisance, and I would like to disable it, if I can. is there a way to do that?

Thanks

Answer:can the automatic update reminder function be turned off?

Quote:





Originally Posted by haskellbob


This friend's computer has this icon in the lower right hand corner, a sort of shield, which keeps prompting her to update programs and so on. It's a nuisance, and I would like to disable it, if I can. is there a way to do that?

Thanks




Yeah. Just click the shield and when the box comes up check "don't show this again".

4 more replies
Relevance 60.27%

Greetings,

When I open an Excel file and minimize it to my taskbar, then open another Excel file it restores the Excel file I minimized + opens the second file in another instance of Excel. How can I get it to stop doing this? I want the Excel file I minimized to stay minimized when I open another Excel file.
 

Answer:Excel 2013: minimized Excel workbooks restore when opening another Excel file

If it's like 2010, it doesn't open a new instance of Excel, just a new window.
I can open a dozen Excel spreadsheets, and there's only 1 excel.exe process running.

The only way to open them up in their own process, without affecting already-opened files, is to manually start Excel then open the file.

At least, I never could find the option in Excel 2010 to always open each workbook in its own process.
 

7 more replies
Relevance 58.22%

Good day,

I was looking for someone to help me in this:

Please see the attached excel file, which automates Groupwise mails for due date reminder. However, it generates individual mails for each due items, whereas, I want one single mail with all due dates. How do I achieve it?
 

More replies
Relevance 58.22%

Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

This was fantastic. Only one issue remaining.
This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.
Awaiting kind help.
 

Answer:Need Help reg "Automatic email from excel based on date "

7 more replies
Relevance 57.81%

Hi

I have excel 2013 (MS Office Professional) running under windows 7 professional

I can open excel files with excel (file/open) with no problem

If I use windows explorer to locate a file, double click on it, I get the following error
"There was a problem sending the command to the program"

I tried unregistering excel twice
I also tried removing the XLB files

Problem still persists

Please advise
Thanks
Natig
 

Answer:Windows 7 Excel 2013 Start Problem

I have also tried uninstalling the program and reinstalling it, no help in there as well
 

2 more replies
Relevance 57.4%

Hello,

I stay in India. I was using Windows 7 and Office 2010. In the regional settings in Windows 7, I had selected "English (India)" and therefore, Excel 2010 was putting the thousands' separator as per the Indian Rules. In Windows 8 also, I've selected "English (India)" in my regional settings, but Excel 2013 is not putting the thousands' separator properly. Here is how it is putting it: 1234,56,789. It should have put it this way: 12,34,56,789. Please help.

More replies
Relevance 56.58%

After starting up Windows 10 from shutdown, Outlook 2013 freezes trying to receive email. If I restart Windows 10, Outlook works.

Interesting to note: The start up from shutdown is very quick--about 1 minute, but the restart takes between 3 - 5 minutes.

Are there any thoughts why this is happening and any suggested fixes?

More replies
Relevance 56.58%

I have upgraded to Windows 10. Before I was easily able to remove the email threads from Outlook but once I upgraded i have not been able to figure it out. Help please!

More replies
Relevance 56.58%

I had a strange email returned from a colleague today.

He sent me a screen capture of an email from me that got flagged up on his MacBook Pro.

This email was sent only to him and yet had multiple email addresses of people that I know in it too. There was also a line in it showing http://themythoffargus.com/give.php?steve

I ran antivirus and malwarebytes and nothing flagged up.

Has anyone else had strange stuff going on?

I am running Windows 10.

More replies
Relevance 56.17%

I have Office Home & Student 2013. After we went back screaming to 8.1 and reinstalled Office, it simply will not open the Word or Excel. Does anyone have a fix??
And one I can do in one sitting/when the baby is napping?
THANK YOU in advance for coming to my rescue!!

Answer:Went back to Windows 8.1 from 10, TROUBLE now opening Word and Excel Office 2013

Repair Office installation or its individual programs.
If you receive any specific error message let us know.

1 more replies
Relevance 55.76%
Question: Email Reminder

Does anyone know how to make Outlook 2000 email reminders continue to remind you of unread messages, say every 10 minutes or so.

Thanks,
Ted
 

Answer:Email Reminder

I think the closest you may get is flags but I am not real sure how they work. You can look in the help files under flags to get more.

Sorry.
 

2 more replies
Relevance 55.76%

I have ordinary excel table with formulas and dates.When formula in cell fill up another cell with notification "SendReminder" i need to cell send me notification on e-mail. I need also to macro runs even when table is closed. Thank you

More replies
Relevance 55.76%

Hi, Its my first post here. I need to send reminder mails from outlook based on excel
I searching for the VBA which according to my needs and I find in this Forum, but I have difficulty understanding. VBA that I adjust not functioning.

I attach the following

I need your expert solution

Any help appreciated and thank you.
 

More replies
Relevance 55.76%

Hy there,

Can some1 help me code a script that will send an e-mail reminder with one date before the DUE DATE based on the date that is in excel. Prb is that i have more the 1 sheets and the date is not always on the same column.

Thanks.
 

More replies
Relevance 55.76%

Hey Guys,

I need some help getting an on-screen (pop-up or message dialouge) reminder based on date entries in my excel workbook. I have gone through other posts suggesting methods to get an Email as reminder, but could'nt figure out how to go about for an on-screen message.

I need a message listing all tasks which have two days left for completion. This should carry on even if the date is passed untill I change the date entry for a particular task.

I wish to have this message at user logon automatically, so will schedule execution of a VBS file which I could find from an earlier post by Zack.

Will be gratefull! for your help.
Thanks.
 

More replies
Relevance 55.76%

Hi All!

I have a list of events and dates for those events and I need to create a system that will email cetain people when those dates approach. I have done a little research but cannot figure out how to make it work. Please help me! LOL Thanks!
 

More replies
Relevance 55.76%

I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fine until the other region updated their Excel to 2013. Now the other region is having trouble with the spreadsheet; namely the drop-down boxes are showing that there are no values, but there should be a list of people in the list. When I open the spreadsheet it works fine. Because the other region is four hours away, I can't just go and look at it on their computer. Is there something that the other region (or that I) need to do to make the spreadsheet compatible with Excel 2013?

Answer:How do I make an Excel 2007 worksheet work in Excel 2013?

Take a look here:http://www.ozgrid.com/forum/showthr...

7 more replies
Relevance 55.35%

I cannot find any way to set an email reminder for an event in Windows 10 Calendar app. Using Calendar at Outlook.com this is an option. Is this by design or am I missing something?

Answer:Set email reminder in Calendar app

How i do it is Calendar App Then Click on the day I want
Click on Event
Fill in the details Click Enter or OK and it is all set to go.
I have mine already done up to Xmas of next year
Just checked and found working ok on mine

1 more replies
Relevance 55.35%

Hi everyone. I am currently setting up a database that will hold employer contact information. This document is going to be used to keep track of when a person called the employer, the part that will require some effort and code is setting up a reminder. In this database I need to add a counter or some form of counter that keeps track of how many days its been since the employer has been contacted.

So in one field we have a spot left for Date Contacted. So based off of the information in that Date Contacted, say I contacted an employer today, what I need is for that counter to basically automatically send someone an email when its reached a predetermined amount of days since that employer has been contact for arguments sake lets just say 5 days.

IF anyone can help me with this I would be grateful, Im not very MS access savey. Currently I am working off of MS Access 2003.
 

Answer:Auto-email Reminder

16 more replies
Relevance 55.35%

I am working on a long list of temporary employees hired with "termination" dates. These dates vary. I want a reminder set to 5 days before the listed "term" date so it alerts me with a reminder. I have seen many different formulas and they work.

The problem I'm having is that there is a long list and that is a "continuing" list...so there are many blank rows. Currently I am using both conditional formatting to highlight it and I'm using the IF formula:

=IF(I2<TODAY()+5,"REMINDER","")

The problem is that it is filling in REMINDER for all of my "empty/blank" rows. I do not want it to appear other than where the data is, but I don't want to have to remember to carry the formula down. So right now I have about 22/23 rows that are filled. I want to expand my spreadsheet out to about 600 rows. But everything past the 23 rows is showing REMINDER even though there is no data in those rows. Is there something I can do to have it carry through the 600 rows, but not put in the reminder until there is data in there telling it to send a reminder? I'm using a MAC with Excel 2017. Thank you for any information.
 

More replies
Relevance 55.35%

Hi GuysHave a few problems with Excel Workbook that I have memory sticked from my old laptop to new computer. Old laptop is Excel 97 - 2003 and new computer is excel 2013Once I loaded the worksheet from the memory stick, I have opened the workbook and it is not working as it has been. I have noticed that some of the Form Control Buttons are missing as wellI have run a Compatibility Check and it has thrown up a number of issuesCompatibility Report for SAS2.xlsm Run on 09/09/2015 14:46 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when opening this workbook in an earlier version of Excel or if you save this workbook in an earlier file format. Significant loss of functionality # of occurrences Version This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. 19749 DASHBOARD'!H6:H29 Excel 97-2003 DASHBOARD'!M6:M29 Excel 97-2003 Excel 97-2003Could someone elaborate on the above, as I am not sure what it is telling meLook forward to a responseTony

Answer:Excel 97–2003 & Excel 2013 Compatibility issues in Win 10

It pretty much means you won't be able to open that file in Excel versions 97 - 2003.

8 more replies
Relevance 55.35%

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

Answer:Solved: Excel search does not work Excel 2013

7 more replies
Relevance 55.35%

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

Answer:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

1 more replies
Relevance 54.94%

I have installed Office 2013 on my Windows 8.1 PC. Since I use Outlook as my email client, I would like it to start automatically when windows start but it should be minimized so it won't bother me. When it is running, it could then notify me of new emails and upcoming events. Is it possible?

Answer:Outlook 2013 automatic Startup. Is it possible?

Perhaps this is what you are looking for...http://support.microsoft.com/kb/251340message edited by DerbyDad03

3 more replies
Relevance 54.94%

Hello.
I've just found a pst file with all my old email. I'd like to put them back on the server (hotmail) but before doing that I've seen that some of them were not recived (or sent) to my actual address (@hotmail.com) but to an old one (@infinito.it). So I was thinking to export them from outlook 2013 to CSV, modify that address into the new one and then import them back on outlook 2013. The problem is that when I export them to CSV, in that file they don't have the date (received or sent) and so when I get them back on outlook 2013 they miss that info.
Can anyone help me doing this? I've been told that VBA macro should be useful for this, but having a look in it I have no idea of what I sould do.
Ah, instead of outlook 2013 I can also use thunderbird (45.3.0) if it's easier with it, but then I'd have to convert that pst file.
Thanks!

More replies
Relevance 54.94%

Oh dear! I created a mail merge in Word 2013 and chose the Edit Individual Documents option under Finish and Merge. I edited each and every email to personalize them. There was no option to email directly from that document, so I went back to the original email and sent them all. To my dismay, every person received an email including a [ ] in the space where I had entered their personalized information! Totally embarrassed. How can I email the edited documents??
 

More replies
Relevance 54.53%

Using Excel: I need to send one email reminder to participants three months after they sign up.
This is only done once.
I need to mark a field "sent" after they have been sent this reminder.
The next time I check for people needing a reminder those marked "sent" will not be sent another reminder, only those who have not been marked "sent".
Thanks for the help.
 

Answer:Solved: Excel send reminder and mark it was sent

Hi, welcome to the forum:
Code:

Option Explicit

Sub SendUpdate()
Call MailData("subject string", "status file updated", "[email protected]")
End Sub

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
.Save ' This property is used when you want to saves mail to the Concept folder
' .Display ' This property is used when you want to display before sending
' .Send ' This property is used if you want to send without verification
' .Attachments.Add (Filename) ' Must be complete path'and filename if you require an attachment to be included
End With
Set app = Nothing
Set Itm = Nothing
End Function

You will of course have to add your macro to send the mail and then enter a true or false in the sent column

A handy link to use ... http://www.rondebruin.nl/sendmail.htm
 

3 more replies
Relevance 54.53%

Hi, this is my first post here and I will preface this by saying I am not familiar with VBA/VBScript language at all (only that it exists and perplexes me), which is why I'm requesting your help!
I have an Excel spreadsheet that I'd like to have send me an Outlook email reminder 6 months after the specified start date, without having to open the Excel file so the macro can run. The reminder email can be simple, just a short message like "Referral Alert: Check Spreadsheet"

I've attached a test file with the columns needed highlighted in yellow.

If this is too tall of an order, I understand!
 

Answer:Send Outlook reminder on specified dates from Excel

As far as I know, this is impossible in the given scenario. Macros only run once a file is loaded; therefore, not having the file loaded means any code won't execute.
 

2 more replies
Relevance 54.53%

For some reason there is a problem with this programme I have built (with help from Computerman) now I have transferred it to another excel file.

When I try to set a Callback Reminder (my terminology), once I have entered the details an error comes up for some reason. The programme has been tried and tested by itself and worked brilliantly but for some reason it doesn't now.

Please use password lfc1979 on the login screen
 

Answer:Solved: Excel outlook calendar reminder

9 more replies