Computer Support Forum

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

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

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!

Relevance 100%
Preferred Solution: Excel help! Automated pop-up box and email reminders, and reminder list

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: 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 80.62%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 79.75%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Please Help ASAP: Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 78.59%

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 93.48%

Hello.
I have been tasked to keep track of follow ups for Implementation dead lines.

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date is 14 days away from being implemented/addressed. 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. J), with subject "Audit Follow Up_Audited Function (Col. A) is due on Due date(Col. I)", and body "Dear Name(Col. K), Reminder - Audit Follow up on Implementation Date"
Also, the script should put a check mark on Reminder sent column (Col. L) 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. I've attached my sample spreadsheet.

Thanks
 

Answer:Automated Reminders excel 2007 thru Outlook

10 more replies
Relevance 80.36%

I have a list of personnell working for us and in one column is their Dates of Birth (DOB) in DD/MM/YY format, what I want to do is filter or show easily who's birthday is coming up in a give period of time. I've tried using the filter function but it only seems to work on the year and I can;t get it to filter on month. I'm using Excel 2007

Any ideas ?

Ian
 

Answer:Solved: Birthday reminders from a list of DOBs Excel 2007

6 more replies
Relevance 77.9%

I am trying to put together a reminder from a spread sheet to email me in say 3 months from a date in a specific cell. is this possible?
 

Answer:excel 07 setting email reminders?

will some one plaese tell me if this is possible?
 

1 more replies
Relevance 77.9%

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 77.08%

Hi all,

I have 3 columns in my spreadsheet - customer name, expiry date, and days till expiry

What I would like is for an automated email to be sent once an expiry is 90 days away. Within the body of the email it would include customer name.

Please would someone be able to tell me if this is possible.

Thank you for your time!
 

Answer:Automated Email From Excel

8 more replies
Relevance 77.08%

Hi all,

I am looking for help on VB script to send automated emails based on the dated column in excel sheet..
I need to send reminders to the email addresses in Column J & K to remind them that the vehicle registration in Column B is due an MOT on the date in Column M, also to send a reminder that the Tax is due on the date in Column P. these emails need to be sent 14 days before the due dates.
I also require Column N & Q to generate at date and time when the reminder was sent.
I would much appreciate any help with this as I am completely new to VB script, I have attached the file to aid in any help
 

Answer:Sending Email reminders from excel to outlook using VBA

11 more replies
Relevance 77.08%

Hello,
I have a excel through which I track the delivery schedules of a large number of IP's for a design.
I looking how I can automate in excel to send reminders to the IP Providers.
Based on the Actual delivery date, I need to automate the excel to send out reminders.
Please let me know how I can do this. If you need to look at the excel, I can send it.
Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

Hi Nagesh!
Wy did U put the same thread twice!
 

2 more replies
Relevance 77.08%

Hi!
I am using Excel to track many IP deliverables for a project. almost 100 IP's
In the excel I have Initial/current/Acutal/date of IP delivery.
Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
Please do let me know how I can acheive this automation.

Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

16 more replies
Relevance 76.26%

I have a project planner (excel 2003) and would like the spreadsheet to email (outlook 2003) me when I have an upcoming due date (preferably the day before).

E.g. Due Date 13.03.2013 would induce a reminder today (12.03.2013)

I won't be viewing the sheet daily and would therefore like this to happen even if the sheet isn't open. Is this possible?

The Due Date is listed in a column.

Are these actions possible? If so, how?

Thanks for your help.
 

More replies
Relevance 76.26%

Hi Guys,

I'm new on the forum so wanted to firstly say a quick Hi!!
But I wonder if you can help as I just cant get an issue solved and I'm sure you wizards of the Excel world can help me.
I am trying to get a spreadsheet to send automated email based on a trigger to say If todays date is within 7 days of the due date Then email a list of people in recorded another cell range

I found the following thread which looks really useful but I am getting constant errors when I try to apply the principle to my sheet.
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

I have table which starts in Cell B3.. (Headings in row 2)
Column A is Blank
Column B is Date Raised - this isnt used for anything
Column C is the Topic Of Work
Column D is the Notes from the meeting
Column E is the names of who the topics are assigned to
Column F contains the list of Email address to send that topic to
Column G is the due date (which I want to email out 7 days prior to)
and Column H is where the macro should make that it has sent the emails

The code I have tried is as follows... but I continually get a "Subscript out of range error"
Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(OpenActions).Select
lRow = Cells(Rows.Count, 2).End(xlUp).Row
For i = 3 To lRow
toDate... Read more

More replies
Relevance 76.26%

Hi Forum,

I'm having a problem piecing together the various bits of VBA I've been finding on the internet in to something I am able to use on a worksheet laid out as follows:

Column A: Date
Column B: Item Description
Column C: Item #
Column C: Customer
Column D: Customer Email address (each cell contains multiple email addresses)

What I would like to do is have the VBA search Column A for any date greater then 6 months in the past from Today, then forward an email to the address in Column D.
The body of the email would need to contain information from Column B and Column C.

Potential problems:
I need an attachment to the email as well.
Customer ABC may be listed several times (once for each item they purchase) and I would like the email to only be sent once (with all the items) versus many times (once for each item that they purchase).
Would like to bcc the sales team and cc the operations team on the emails that go out. Those email addresses would be static - the "To" part would need to change based on the customer.

I've gone to Ron DeBruin's site but ran in to some problems with the codes that I was trying to change to meet my requirements - so I tried downloading the add in and unfortunately, I am unable to do so from work.

Can anyone help or am I doomed to sorting manually?

Thank you in advance!
 

Answer:Solved: Excel - VBA Automated Email

12 more replies
Relevance 76.26%

Hi All,

I am new to VBA and although there are many links in the forum regarding the topics of using Excel to send Email reminders to Outlook, my requirement requires an additional option which i do not know how to program to make it work. I hope I can be assisted.

I am currently using Outlook & Excel 2010, Windows 7.

Using the attached test example, I have created a spreadsheet which is used daily. It requires a reminder email to be automatically sent out ONLY if the following is triggered.

Row H (Send Reminder) must show YES, then it will only send on the date shown on Row G (Due Date). However, if Row H shows NO, it will not send even though Row G has Due Dates.

The body of the reminder message would say:

Subject: Reminder

The project assigned to you under reference number, "cell D3" in the name of "from cell E3" for the confirmation date of "from cell N3" is now G3 - C3 days old.

If this has been completed, please ignore.
 

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.44%

Hello,

I am currently attempting to setup an inventory file in excel to send myself and another colleague anytime an item in that inventory is to expire. I have found a command set from an old comment thread that I have been using as a template but I am not well versed in basic and cannot find where the all of the errors are occurring. So the worksheet utilizes columns a-q, with column Q where the date and time of the sent email will go. I have column A as the item to expire, and column K as the date of expiration.I currently have column p as the location for the email address to be sent but I would rather build the email address into the code since it will only be two email addresses used for the notification. Below is the code that I have been working on but it isn't working for me. Thanks in advance for any and all help.

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String

With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With

Sheets(1).Select
lRow = Cells(Rows.Count, 16).End(xlUp).Row

For i = 2 To lRow
toDate = Replace(Cells(i, 11), ".", "/")
If Left(Cells(i, 17), 16) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

eSubject = "Test Article " & Cells(i, 1) & " expires " & Cells(i, 11)
eBody =... Read more

Answer:Automated Email for Expired Inventory in Excel

16 more replies
Relevance 75.44%

Good Day,

I would like assistance in creating a code that will generate a automated email to specified receipients when a date is entered into a specific cell. I have attached a sample spreadsheet. When a "date" is added in column M, it automatically generates a email to specific recepients notifying the receipients that the specific unit number in column A has been completed.

For Example:

Good Day,

This is to notify you that unit *** (from colum A) is complete and ready for your team.

Thank You,

xxxx

Thank you very much for the assistance!
 

Answer:Solved: Sending a Automated Email Through Excel

8 more replies
Relevance 75.44%

Hi everybody,

First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software.

I seen current thread that were very close to what I need but was unsuccessful with achieving what I needed.

I'm trying to set an email reminder sent to my team when a task has not been completed (Column D) by the due date (Column C) and some indicator on column H when completed. It would be most ideal if the subject had the part number "123453 Rev 06 Doc Control Update" and body said Dear Andy(Task Owner) reminder, please update documentation related to your department. Thanks.

I currently have a macro for 'Task completed' be filled in a green color when complete. I'll copy and paste below what i currently have. I know this is probably a long shot but I am getting somewhat stressed and losing hope with this, please please please help. function is more critical for me then the looks, if i have to move some cells around I don't mind one bit.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim... Read more

Answer:Automated email in excel, driven by due date

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(1).Select
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
toDate = Replace(Cells(i, 3), ".", "/")
If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 4) 'gets the recipient from col G
eSubject = "Document Control Status update "
eBody = "Reminder," "Please update your project status."

On Error Resume Next
With OutMail
.To = toList
.CC = ""
.BCC = ""
.Subject = eSubject
.Body = eBody
.bodyformat = 1
'.Display ' ********* Creates draft emails. Comment this out when you are ready
.Send '********** UN-comment this when you are ready to go live
End With

On ... Read more

1 more replies
Relevance 75.44%

Hi,
I am a summer student for a concrete company and I am responsible for keeping all of our MSDS up to date. I have a spreadsheet set up to summarize it and that includes expiration dates. Currently the dates change color when it is within 30 days of expiration and to red when it has passed the expiration date. My problem is I have other jobs to do at the same time and don't check the sheet daily. Is there a way I can have Excel email my outlook account when the msds hits 30 days before the expiry?

P.S. I'm running excel 2010
 

More replies
Relevance 75.44%

Hi I would like to get VBA/macro codes to send an automated email to the email IDS mentioned in the file when the invoice due date is less than 2 days of current date. please help me
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Here's a similar thread on the forum. If you can follow the code, then you can adapt it to suit your needs.
 

1 more replies
Relevance 75.44%

I'm in HR and I have a spreadsheet that incorporates staff information commencing, with each month in a new sheet. Unfortunately, department managers are forgetting to do staff reviews at 3mth, 5mth or the 6mth probation. I've entered formula to calculate these dates from the staff commencement date.
Now I need to find out if I can have some sort of Macro or VBA coding to email me a reminder to contact the managers a week prior to the the review/probation dates.

Please help! I have no idea with coding/programming etc.
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Try the attached, one thing to note that you had the probation dates in the wrong place

6mth, 3mth and 5mth

so I changed it to 3\5\6

when you open the workbook the macro will run and generate an email IF any dates is below or equal to 7 and above or equal to zero. Meaning that there is a week until the review is required. This code will fail if the review date is in the past, this can be changed to tell you that a review date has been exceeded.
 

1 more replies
Relevance 75.44%

Hi Everyone!

I need your help in sending automated email and text message, when the due date of a PO is a week 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. E), with subject "PO (Col. A) is due on Delivery date(Col. C)", and body "Vendor (Col. D), please update your project status".

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 most of threads using Outlook only (my default email is Mozilla thunderbird),I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Send email reminders thro Thunderbird from Excel sheet

16 more replies
Relevance 75.03%

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 75.03%

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 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%

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 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 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 74.62%

Hello everyone,

I'm hoping that I can get help with my issue at hand. I have a problem that from the looks of it has been asked a few times. However my understanding of excel and visual basic is to very limited to solve my problem without any help.

Here is what I'm faced with:

I made a workbook for keeping track of maintenance and DOT requirements for the trucks in our yard. Each sheet is set up with service date or inspection date visual reminders based off of conditional formation. I get a visual warning (X) amount of days before and a past due warning 1 day after, all depending on my requirements.

After searching the forms I found a thread that looks to be the closest that I can find to my needs. http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

Since I have multiple dates and need for an email reminder the coding gets confusing to me. I have a very basic understanding of coding principals but have never used visual basic.

What I would like to happen based off of my understanding of the other thread:
Using task scheduler run a VB file that would then open the Excel file everyday at (X) time and check my date parameters and send an email with a warning that a due date is coming up or if past due then an email saying it is past due. The close file.

I'm sure more information will be need to give me any type of help. I have attached the workbook for reference and so my explanation will make more sense.

I'm ... Read more

Answer:Excel: Automated email based on Conditional Formatting

Hi there, I noticed that your post has gone unanswered, you posted on March 25th an looks like nobody has taken a chance on it.
You mention you're using office 2013 but your file is Office 2003 or earlier; I assume this is a file you've been using for quite some time.
What you're asking is in a certain way not that complicated but needs to be thought about very carefully. Usign the scheduler to open the Excel file, check it and then close it is not that muvh of an issue but you do have to realize that if you're using Excel for something else and all at once the scheduler triggers it you could run into some problems and might loose the data you're working on.
In the 'Abq Truck & DOT Reguirements' sheet you've got 4 columns with dates, which one is the one you trigger the mail on, all four? What email address?
Conditional formatting is nice for visual triggers but will not trigger a macro so that all together will be some vba code which needs thinking and writing.
The samples on other posts can of course be used and like you say some coding / vba knowledge is required to adapt it to your needs.
Think about it and update with some extra information, maybe some simple code can be written and used
 

1 more replies
Relevance 74.62%

Hello Everyone,

Let me tell you about myself, I am Rajesh, working in a private organisation. I am doing my MCA post graduation. I have to do a repeated task everyday in my office, that sending an excel sheet to all my team members in TO field and two members in CC field. I use Outlook 2007 and Excel 2007. I searched the forum for similar threads they exist I think, but I couldn't get what I need. Let me explain you all what I am going to do everyday

There is a network drive in which I need to take list of sub folders available in four different folders and create four text files and I need import it in a single Excel sheet, after completing this the excel sheet must be saved as "<DD MMM YY> Archive" (Current date, month and year) and emailed to 9 team members(TO field) and 2 members(CC field). It is not necessary to create a new excel file everyday, just overwrite it with previous one.

I have found how to get data automated to excel from a network drive, that is I use batch file that runs commands to get the text files using a VBS(windows scheduler).And then get the data by using Import Data from Text option in excel, But I don't know how to make automated emailing as easy as possible with current date, month, year in excel sheet name.
I hope I am clear in my question, please ask me If I need to provide more information. Any help would be appreciated.

And I found this forum by googling for the above task, I read many posts and seen here member... Read more

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 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%

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 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 73.39%

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,
 

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 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 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 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 72.57%

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 72.57%

Hi,

Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???
 

Answer:Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

10 more replies
Relevance 65.6%
Question: excel email list

I have a excel document with columns of usernames and email address, i need to some help getting them email compatible, in this form:

"########" <#######@####>, and so on.........

The info is sensitive, so i will email it to you.

Thanks
Danny
 

Answer:excel email list

9 more replies
Relevance 65.6%

I have an Excel spreadshhet with a column of email addresses and I would like to use it to set up some email 'Groups'.Is there an easy way to import or use the list of addresses without re-typing them all out?I know there is software on the market which does it, but thought there might be another way.

Answer:email list from Excel

Assuming Outlook Express (although other e-mail clients may be similar).Convert the Excel spreadsheet to a CSV (comma separated values) file.In OE go to File; Import; Other Address Book.Choose Text File (Comma Separated Values), click Next and work through the wizard.

1 more replies
Relevance 64.78%

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 64.78%

Hello,

I have an Excell sheet that I have entered many email addresses into as well as the persons name and area they reside in - all in different columns. I need to be able to send a mass email to all the addresses and then also be able to filter the addresses by the different areas the people live in. Example- send all the area 1 people an email. I understand I can copy the addresses into Text and paste them into the BCC of my email; however, I want to be able to use the Excel sheet to filter the addresses down and just clik on something and have the addresses appear in my Outlook BCC email area. I am trying to avoid having to create Text lists every time I want to send out emails to multiple addresses. How best can I use my Excell sheet as a one stop Emailer?? I have a basic understanding of Excel and any help and your patience - is appreciated.

thank you
 

Answer:Excel email distribution list

16 more replies
Relevance 64.78%

I am looking for a way to make a email distribution list in excel. The information in the sheets is a follows. Name, Group, and up to 10 email addresses for each person. what I need to do is have 1 button to click on and have an email composed with all the email addresses on that sheet put into an email. I have found a post on the forums that does almost this but I don't know how to change it to what I need. I have attached it so you can look at it.
 

Answer:Excel email distribution list

11 more replies
Relevance 64.78%

I have a list of my club embers in Excel. I want to create a New Group in Outlook Express. Let us say, I named it "VolleyBall team".In order to input email address of each member, I have to do it one member at a time - this takes a lot of time.Is there a simpler way to copy all the em-addresses from Excel into the New Group?Will appreciate your help.Mike

Answer:HOW TO IMPOERT EMAIL LIST FROM EXCEL

How are you doing one member at a time? In my Outlook Express I can only import from a .wab file.

2 more replies
Relevance 64.37%

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 64.37%

As I understand it, when we have to select a filtered (subset of our) list - we must create the filster list using an ADVANCED filter; then copy it to the SAME worksheet. Then cut it to another sheet; then save it as CSV; then import it into an email client; then send our email.

A lot of work just so that we dont email to the entire list when we only desire a small group.

Is there an easier way - or are we misssing something?
Excel add-on? Macro?

We are using Gammadyne for our customer list emailings; and MS Excel for our customer list. Gammadyne does not use Excel cause it does not have 'ODBC' (or does it)?
 

Answer:Easy way to manage an email list with MS Excel ?

6 more replies
Relevance 62.73%

I have a list of emails in Excel 2010 that are like this:Row L2:[email protected],[email protected] L3:[email protected],[email protected] L4:[email protected] L5:[email protected],[email protected],[email protected] would like to extract all of the emails from a specific domain (@second.com). The text to columns just splits them at the delimiter. Any ideas on how to extract based on the domain? Please and Thank you!

Answer:Excel 2010- extract a specific email from a list of emails

What is the maximum number of email addresses that you might have strung together in a given cell?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 60.68%

Um... good day to everyone.  I have a question, its really not that serious but i will really appreciate it if somebody can help me. The thing is i clicked this dialogue box (internet explorer)regarding the 'automated search' i think. i clicked yes. and everytime i search for something it shows the previous words i searched. ex. i typed in 'blue' in google there's a drop down list of the things i've searched.Now what i'm trying to do is look for that dialogue boxor simply a way on how to remove/reverse that functionbecause i'm sharing my PC with someone and i don't think i want them to see all the searches i've made.  i hope someone can help me with this. thanks!

Answer:automated search (the one in the drop down list)

press F1 and search for autocomplete. Or search the forum here for that term. This gets addressed on a weekly basis.Be careful on those risky sites. You can get more than embarassment by visiting.  

1 more replies
Relevance 59.86%

The cash is truly is in the rundown, so why are you treating your email list like your in-laws. Basically enduring them just to get what you need. Fruitful online advertisers comprehend that the shrouded mysteries to successful email list showcasing begins with the nature of your association with your rundown. Viable email list showcasing is a standout amongst the most imperative pieces to network advertising achievement on the web. On the off chance that you are not building a ceo email lists rundown or not dealing with the one you have you should toss cash out the window. It's as basic as that. The thing is, regardless of the fact that you're ready to manufacture a huge rundown, itdoesn'tmatter unless you know how to do the accompanying: Comprehend the force of email copywriting Comprehend the significance of building connections With so much center put into online lead era, it can be hard to make sense of what to do with those leads once you've gotten them. Amplifying your benefits online comes down to building a responsive email list and on the off chance that you take after the shrouded insider facts I am going to lay out for you, you'll have the capacity to make the most of each supporter. See, it took me months to figure out how to my make a viable email list promoting effort and to get my rundown to "react" to me. I had drives that I did not understand what to do with. I was terrified to connect with them on an individual level throu... Read more

More replies
Relevance 59.04%

Hai,

1. Manage to calculate total value inside my list box by using excel vba script,
TextBox16.Value = ListBox1.ListCount and it shown actual text enter per each row.
Can anybody assist what is suitable list count script to used if we need to count total number
of specific text enter at column or row [Example: Apple]

2. Based on script below I can make my excel worksheet cells flash with vba;

Sub makeCellsFlash()
Dim mydate1 As Date
Dim mydate2 As Long
Dim datetoday1 As Date
Dim datetoday2 As Long
Dim x As Long
lastrow = Sheets(?sheet1?).Cells(Rows.Count, 1).End(xlUp).Row
For x = 2 To lastrow
mydate1 = Cells(x, 2).Value
mydate2 = mydate1
datetoday1 = Date
datetoday2 = datetoday1
If mydate2 ? datetoday2 = 3 Then
Cells(x, 3) = ?Yes?
Cells(x, 3).Interior.ColorIndex = 3
Cells(x, 3).Font.ColorIndex = 2
Cells(x, 3).Font.Bold = True
End If
Next
startTimer
End Sub
Module 2 contains the VBA code for the timer:
Sub startTimer()
Application.OnTime Now + TimeValue(?00:00:01?), ?color_cells?
End Sub
Sub color_cells()
With ThisWorkbook.Worksheets(?sheet1?).Range(?C2:C6?).Font
If .ColorIndex = 3 Then
.ColorIndex = 2
Else
.ColorIndex = 3
End If
End With
startTimer
End Sub
Sub endTimer()
Application.OnTime Now + TimeValue(?00:00:01?), ?color_cells?, schedule:=False
End Sub

Can anybody assist same script above to be used inside list box

Tks
 

More replies
Relevance 58.63%

I have a spread sheet that contains review dates in some colums. Is it possible to link excel to outlook so I automatically receive reminders via outlook a week prior to each date. I have been told it can be done but I am not sure how. Any help will be appreciated.

Answer:Excel/Outlook reminders

You would need to run a macro in Excel. click here may get you started.

2 more replies
Relevance 58.63%

Hi guys! I've been looking on this forum for quite some time and I did find some useful information about creating outlook reminders in Excel. However, I didn't find exactly what I am looking for.

I need to create different reminders using information in the same line. I have attached an example of my document. I have 12 tabs, each representing a month. All upcoming groups are separating by their arrival date. Each group has either 1 or 2 deposits required by a certain date, And some groups have a rooming due by another date.

For exemple, in January, I have Montcorr coming. 1st deposit is due on 12/30, 2nd deposit on 01/02. The rooming list of due on 01/09. As for the deposits, I need to receive a reminder the day of. As for the rooming list, I need a reminder 3 days before the due date.

Can somebody please help me out? I know this might be a little complex... But thank you!!!
 

Answer:Set multiple reminders in Excel

14 more replies
Relevance 58.63%

Hi im trying to sort out a system for work that allows me to receive e-mails about 2 weeks before a piece of equipment is due to be calibrated. This runs on a yearly cycle but we have enough equipment to be doing this every week. I have set up an excel sheet with all the information on and currently have to scroll through this all manually which is time consuming. I noticed the thread

http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel-3.html

And this sounds like what I am after but I have no idea what any of the info means or where to start, can anyone help me please.

Or does anyone know of a good free software for asset tracking and data logging???
 

Answer:E-mail reminders from Excel

7 more replies
Relevance 58.63%

Hi
i would appreciate some help with this.
i have a spreadsheet with delivery dates. i want the cell next to date highlighted when its due for delivery.
Please see the attached spreadsheet.

Thanks in advance.
 

More replies
Relevance 58.63%

Hi All,

I have a File in which i store all the billing records of my transmission circuits, but most of the times, i missed billing of some circuits or vendor didn't send the bill.

Is there any mechanism in Excel 2007 through which i get notified either via Popup or email or ballon notification about the missing bill?

An urgent help would be helpfull.

Azfar
 

More replies
Relevance 58.22%

I have to take medication twice a day and I'm too often missing the second one about 10pm. It would help if I had a daily email reminder about this as I should hear the reminder arriving, either on my laptop or on my phone. Gmail help says this is possible - see pic - but nowhere can I find the Create button. I don't want to create this as a forever recurring event in Calendar as it clutters up the display too much.

Any ideas?
 

Answer:Email reminders in Gmail

Earthling said:





I have to take medication twice a day and I'm too often missing the second one about 10pm. It would help if I had a daily email reminder about this as I should hear the reminder arriving, either on my laptop or on my phone. Gmail help says this is possible - see pic - but nowhere can I find the Create button. I don't want to create this as a forever recurring event in Calendar as it clutters up the display too much.

Any ideas?Click to expand...

I use this gadget - sits on my desktop and can be set for multiple times and is customizable to notify you with a song on your comp, if you choose to do so.

https://sites.google.com/site/gdesktoparchive/gadgets/tools/date-n-time/clocks/digiwatch-old
 

10 more replies
Relevance 58.22%

I am a very old lady and, though still competent, tend to forget. Particularly, I tend to forget to look at my calendar where I write down commitments, etc. I have now twice forgotten to pay taxes on time, and I forgot to attend a lecture for which I had gotten a ticket a while earlier.

But I do look at my email every day. Is there a way I can set up a calendar that would automatically send me an email at a certain date, reminding me to pay my taxes, upcoming birthdays, etc.?

I use exclusively Operamail.com for email. It's my home page. I did discover such a calendar at Google and entered crucial dates on it, but since I never look at it (and would forget to look at it the way I forget to look at my paper calendar), it really doesn't do me any good.

Please, any suggestions?
 

Answer:automatic reminders by email

"calendar at Google" -- if you navigate to that, then open your Operamail.com in a new tab, then go File > Session > Save this session, then assign a session name, then make sure "Show these tabs every time I start" is checked, then click OK ...

... you'll get your calendar page and your mail page every time you fire it up.

HTH
 

1 more replies
Relevance 58.22%

Hi

Can anyone please assit me on how to make an Excel workbook give me a reminder via Outlook.
I want a reminder that will tell me when a specific task has not yet been completed.
we send requests to a custodian when we a looking for a document. on the excel sheet we enter the date we sent the request, but I want a reminder when the received date column has not been updated if I have not received the documents within 3 days time in order to follow up with the person.

can you pease assist me

regards
 

More replies
Relevance 58.22%

Hey Everyone,

First post here. I was fallowing this thread:
http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

And i have a similar problem i could use some help with. Now that i think about it it might be harder than original thought of. I have a workbook with 12 sheets, one for each month. For each month i have a list of Magazines titles all in separate rows in one one column. to the right of those, i have each day of the day of the month. I have attached a sample spreadsheet of what i mean. On any day a sales rep will call me and book a day they want to send a email, or eBlast message to subscribers of the particular magazine they choose. I would love to have the option to have an automatic email send to each sales rep 5 days before ther scheduled booking is to be sent out, only problem is how would i extract the email address from a comment in excel, and have ti send a email to that person?

Another idea i had was to creative a booking sheet for which each sales rep would fill it out with fields such as Clients Name, Date to send email, Type of email, Geo targets, creative elements in email etc etc. is there a way that once i approve this and send back the excel file with an approved icon or logo and some notes, can it automatically, even without being open, send an email or reminder to the user i sent it to?

i greatly appreciate any comments as i know i most likely trying to ask for the world here.

Thanks!

Connor
 

More replies
Relevance 58.22%

Hi friends,

I have not used Excel for ages apart from basic adding formulas etc.

What I am trying to do is make a set point (date) that turns a box red if one year has passed since the original date entered.
(not sure if I have explained it very well?)

ie
I am making a list of alarms on some machinery & want to show that the alarms have been tested within the past 12 months.
If I do not get around to testing, I would like the relevant field to change colour, so that a simple check upon opening the spreadsheet will tell me what is overdue on testing.(eventually there will be a lot of different alarms within the spreadsheet)
I am not sure if it will be easier to make an "issue date" then another field for "review date" or just have the one field that will turn red if today's date passes 365 from the last test date? (is that possible?)

I am sure it is easy - unfortunately, not for me!

keep the faith

Rob
 

Answer:Excel formula for annual reminders

You need to apply conditional formatting to the cell you want to change colour.

Condition is the formula type. Formula is

=today()>=(yourissuedatecell+365)

In the formatting, select fill colour to suit and any special borders / font formatting. Hit apply.

You can change the range affected by the formatting, but you might need to lock the column / row, depending on what you're trying to do.

No need for a due date field
 

3 more replies
Relevance 57.4%

I used Outlook 2000 on my last XP computer but Outlook 2000 does not work on Windows 7. While I've found a number of email clients that do the email job credibly, I can't find an email client program with a calendar that has reminders like Outlook. That is, I want something to pop up on my screen to remind me I have a dentist appointment in one hour, or I have to go someplace tomorrow, or I have a deadline coming up in three days.

I prefer something that resides locally on my machine. The calendar in Windows Live Mail is nice, but no reminder function. I think if I go online and register with Windows Live, they may have some sort of option where they send you an email reminding you of appointments, but that doesn't sound like the reminders function of Outlook. Besides, Microsoft knows enough about me already, I don't want them tracking my appointments.

Does anyone know of a resident email client with a calendar containing a reminder (alarm) function?

Thanks!

Answer:Looking for email client w/calendar w/REMINDERS

I personally do not know any free ones...

I know Office 2007 in Outlook as this function.. and Office 2003...Which are able to run under Windows 7..

You could just get Outlook and nothing else if you already a use a Office Program..(I just looked at the price it would be cheaper not to get the whole Office Suite...and just Outlook

Hope this Helps..and Happy Holidays..

9 more replies
Relevance 57.4%

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

More replies
Relevance 57.4%

Hi,

My excel sheet has 3 columns.

1st column has email ids
2nd column has has Name of employee
3rd column has their respecive DOB

My requiremnet is;

An auto generated email (saying "today is xyz, abc's birthday") should be sent to everyone in the list whenever there is someone's birthday.

Also, can this be achieved even if the excel sheet is closed? If we use the google spreadsheet and write some script for the auto alert? let me know if this is posible.

Please help

Rgds,
Saqib Khan
 

More replies
Relevance 57.4%

Hi guys,

I have read tons of pages from this forum hoping to create a killer excel workbook so my daily tasks can be completed way faster and more efficient, however I have hit a brick wall. That brick wall is called "How in (insert whichever holy character you want)'s name do I get Outlook to obey Excel".

My request is rather simple, yet I don't have the brains for it. Once a week, probably on Monday, based on the attached excel, I want to send specific e-mails to colleagues informing them which documents should they start writing based on the "Deadline to be filled" column and to also inform them what is going to happen based on the Column "When will it happen". Here's how I think the code should be displayed in my humble and unadvised opinion:

If "Col G" = yes, then do nothing
if "col C" is between today() and today()+7, then e-mail must be displayed
Subject = Work schedule
To: ?Col E?
Cc: ?Col F?

Body:
?1ST PART - I am trying my best to understand excel/vba language, so I'm adding hypens like y'all pros when I do a comment

Dear colleagues,

The following actions must be completed this week:
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- Preliminary hearing for Yellow SRL ? 09.05.2016 (example)

?2ND PART

Also, if "col D" is between today() and today()+7, then the following tex... Read more

More replies
Relevance 57.4%
Question: Automated Email

I have quite a question I feel. The short version is that I would like to find a way to send email using Microsoft Excel 2003 and Lotus Notes 7. In my excel file I have reminders created to show when a project or paperwork is due for certain clients. I have reminders set to show based on different amounts of days, 30, 45, 90, just a few examples. On my alerts sheet, each row is a different client and each column is different paperwork due. I have tried creating a macro to send an email when alerts in the range are present which no look. I also have a column of email addresses that I would like the reminding message to go to.

I basically want to be able to send email in lotus notes to automatically to clients with alerts. The other clients cells are blank when there are no alerts. I need each row to be sent to the corresponding email address in that row, but i need each column to generate different subjects and bodies depending on which column the alert is present in.
 

Answer:Automated Email

Hi, welcome to the forum.
Have you done a search on hhtis forum, there are quite e number of posts with answers and examples of how to trigger mail.
The only thing you will have to finc out is the code necessary to trigger Lotus Notes 7 but the web will surely privide for this.
 

2 more replies
Relevance 57.4%
Question: automated email

At my company we use a automatic emailer to send report to endusers. For some reason my reports fail to go through to my AOL email address. I will show you the message I get back. It does work with other services we've tried but not AOL or Prodigy yet. Any assistance you may be able to give will be welcomed.

----Transcript of session follows----
...while talking to zc.mx.aol.com.:
>>>MAIL From :<[email protected]>
<<< 550 REQUESTED ACTION NOT TAKEN: DNS FAILURE
554 [email protected].. Service unavailable

If there is a cure for this error please let us know. You can reach me at [email protected]

We are using a unix mail server,
also a private domain name of namdg.com.

Hope this helps.
 

More replies
Relevance 56.99%

I have a Excel Spreadsheet that currently generates a automated email through outlook. My company recently transitioned from Outlook to Gmail (our email addresses did not change). Is it possible for the spreadsheet to generate a automated Gmail? Thanks for all the help.
 

Answer:Automated Gmail Through Excel?

As per my experience you can send email via Gmail's SMTP servers using CDO - http://www.rondebruin.nl/cdo.htm
 

1 more replies
Relevance 56.99%

Have seen a few topics on here about this, and it's obviously WAAAAY out of my league.
We have a register of all our operators & drivers and all their various qualifications. I am after a way to set up e-mails or alerts to myself and 3 colleagues whenever a persons expiration of a specific qulaification comes within say, 60 days of todays date. Each person may have up to 20 different expiry dates.
At the minute, I only have a simple conditional format in place showing me Red when expired, Orange within 90 days, and Green when OK. Someone obviously has to physically check this though every day
 

Answer:Automated E-Mails from Excel via VBA

well, it sounds quite similar to the solution I gave this poster...

http://forums.techguy.org/business-applications/940910-emailing-excel-based-off-cell.html

you will need this program to click Yes for you.....
http://www.contextmagic.com/express-clickyes/free-version.htm

If your email security blocks excel from sending
 

1 more replies
Relevance 56.99%

I just reinstalled Vista due to viruses. I was using Office 2000 with a large .PST file with important emails and folders. After failing with 2000 and having lockups and crashes trying to open up outlook I got and installed Office 2007 thinking it would work better with Vista. I launched the new outlook and it automatically imported my settings from the previous version. Briefly I saw that it imported my folders and old emails, then it started hanging. My cursor rapidly blinks the arrow and twirling circle icon. If I try to move the window it says "not responding". When it did free up it popped up a window saying there were over 2000 reminders. I assume it's seeing all email as new and it thinks it has to remind me off all of them. I would tell it to ignore all of them and then it starts hanging again. I've tried turning off reminders in the advanced options of "other" options but when I relaunch outlook reminders are checked off again. I've tried launching in safe mode with "outlook /safe" and still ge the above problem. Once it finally stopped and I was able to download my email but I think reminders came up again and crashed my machine. It could have been another issue though. Now I've launched again and it's been hanging like this for over 10 minutes. What is it doing? Scanning my emails, something with reminders? Should I wait. Any help is appreciated. I simply cannot start over and loose my old email (.pst file). Is that... Read more

Answer:Email broke: Problem with Outlook '07 reminders, etc.

I would wait outlook 2007 is a bit notorious for not being able to handle large imports and then having to reorganize everything then having to try and import new mail so just let it do its thing and let it be and see what happens.

1 more replies
Relevance 56.99%

Hi Everyone!! This is my first post here. I need your help in developing a method of sending automated emails on Gmail when the due date of Insurance payment is 7 days before the current date and an email when the due date has expired.

So as per the attached excel file an email should go to (Col H) when due date (Col F) is 7 days before current date, with the message "Payment of Rs. (Col E) is due for Policy Number (Col D), (Policy name (Col C)) for (Owner name (Col B))"

I have searched through various forums for similar problems but could not really find a solution, as I am not proficient with VBA to tweak the code as per my needs.

Any help would be really appreciated!

Thanks
 

More replies
Relevance 56.99%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3037 Mb
Graphics Card: Intel(R) G41 Express Chipset, 1294 Mb
Hard Drives: C: Total - 305242 MB, Free - 67280 MB;
Motherboard: LENOVO, To be filled by O.E.M.
Antivirus: System Center Endpoint Protection, Updated and Enabled

hello

i am new here i might stumble a bit, my apologies in advance. i am a Marine engineer by profession and now i have been helping out in the office since we don't have a Technical Manager, my computer software skills are also limited that is why i need help.

i have 45 crew reporting to me with all sorts of certificates with different expiry dates. i have managed to compile an excel spreadsheet with their names including certificates but since i am in between operations and the office i need excel reminders to my emails and to one nominated person at least 60 days before expiry to avoid catastrophic shipping delays while people are revalidating their certificates.

please find attached spreadsheet with names and relevant certificates (highlighted in green). your assistance will be forever appreciated. i will be glad if i can able to do it by myself so when changes are needed i can just execute them. thank you in advance.
 

Answer:excel spreadsheet with expiry dates auto reminders

I would not be able to code this, but a coder would have needs/questions:

1. A worksheet with Name and Email address. This is so that info does not need to be hard-written into the code.
2. When do you want it emailed? When you open the file? Automatically, even if you don't open the file? With a button click by you?
3. What version of Excel and Outlook are you using?
 

1 more replies
Relevance 56.58%

-I have this webcam software that automatically takes pictures whenever it detects motion
-it does not support email
-how do i upload pictures automatically using gmail or some online back solution that uploads?

Answer:automated upload / email?

Batch file. Get the GDrive and transfer the pcitures from where you take the screenshot to the GDrive which will upload it to a GMail account. IT wont be able to be viewed online like they are but you can use the space.

If that doesnt work. Batch file so it uploads using the Photobucket Mass uploader or something.

6 more replies
Relevance 56.58%

Hello,

I'm looking for either freeware or shareware automated email software. I need the software to read addresse from a ascii file, excel ect., one at a time (until end of file), use the attachement file - also listed in the ascii file, then send the information to the email address automatically. This program should be able to do this until it reaches the end of the addresses in the ascii file (or other file format). Anyone know of a automated email software pkg. which can do this?
 

More replies
Relevance 56.58%

hello,

I need some help in figuring out how to send an automated email message from an excel spreadsheet to my outlook. My basic requirement is that when the value in a cell ( in my case it is the number of left over days until the deadline) I require an automatic email to be generated and sent to me when the value in this cell reaches a certain threshold value.

thanks
 

Answer:Help with sending automated emails from excel

Welcome to the forum.
If you do a search on your subject you'll finde several posts with the same question. I think the results can help you.
 

1 more replies
Relevance 56.58%

Have attached notepad with few data. What exactly i need is listed below:

1. I have 27 folders in my desktop where all the folders contains one notepad as attached.
2. I need a excel macro file which automatically pick the notepad from desktop in that the certain folder.
3. And convert them into excel and save it in the same folder.
For eg: If folder 1 have notepad file with the name "123456", then excel file should save in the same folder where notepad was picked with the name "123456 "B" Ctns "D" Pcs". B- Countif the total "B" and Sum if the total "D"
4. Excel file should do "Text to coloumn" the data in notepad file.
Text to colomn:
*Delimited - Next
*Enable all the Delimiters excep "others" - Next
*Enable "Text"in "Column data format" for first 2 coloumn - Finish.
5.Once everything done in sheet 1.Sheet 1 should take copy of that data and save it in another sheet.
6. Coloumn "A" having a Data of "B" and "D".
7. Add one new coloumn in "A".
8. "B" is the header of "D". So Every header should come left side to "D".
For eg:
IF the DATA is
B STMEGY05066
D 12345678999 8
D 25874136987 9
B STMEGY05067
D 36982117852 10
D 78945612365 2

I need the data like below,

STMEGY05066 12345678999 8
STMEGY05066 25874136987 9
STMEGY05067 36982117852 10
STMEGY05067 78945612365 2

9. Once the above is done. then do pivot th... Read more

Answer:Automated Covertion of Notepad to Excel

16 more replies
Relevance 56.58%

Hi all,

I know this has been posted a few times already, but I am a programming noob and I'm having a bugger of a time altering the code that forum members have already given to others to suit my needs.

What I'm looking for is this: I have a master excel (Office 2013, operating on Windows 7) sheet with numerous tabs (one tab per customer) that has a) their requested dock date for their parts and b) the date I sent them their final invoice, which they need to pay within 30 days. I am trying to get excel to send me an e-mail (to Outlook 2013):

1. 5 days before their requested dock date (so I can make sure our production staff have everything under control and it will be shipping out as scheduled)
2. 5 days before their payment is due (so 25 days from the date I said I invoiced them) and
3. If possible, it would be great to receive an e-mail on the date payment is due as well, as well as in 5 day intervals until payment is made.

Another difference is that I would like all e-mails to go to me, not directly to the customer (so no variable e-mail addresses).

Is this possible at all? I've attached a example of the spreadsheet I'm working with if anyone would be able to help.

Thanks!
Arianna
 

More replies
Relevance 56.58%

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

More replies
Relevance 56.58%

Hi

I just started to use MS Excel and I'm having trouble entering data in one specific catalogue.

In one column in that catalogue are digits, and what I have to do is to multiply them all by certain value and then add percentage to them.

Is there a way to do it quicker then one cell at the time, it okay now but as the info building up it will become a genuine pain in the you know what...

Thanks in advance
 

Answer:Excel help - automated process, converting etc.

10 more replies
Relevance 56.58%

I have a sales report that automatically updates daily. Is there a way to setup automated emails from excel to different individuals? It would save so much time and effort. Any help is appreciated!
 

Answer:How to send automated emails from Excel?

There are quite a few similar threads with sample files and more.
Check these out.
There are two I helped with, one on October 13 was asked by vasu0505 and one from June 22 placed by truec
Search for posts by these posters and you'll come across them,

With the information you have given (Excel version missing) and no data explaining it's an open guess and guessing is no option

When you open this post similar threads are displayed below so you can directly click them.
Happy hunting
 

1 more replies
Relevance 56.58%

HiI have a few worksheets with expiry dates, I was wondering if there was a way to set up an email reminder when due dates are approaching - and then again when due dates have passed.all of my due dates in are in column D, but not every row, they skip rows if that means anything. I just need the emails to come to me, not to everyone these dates belong to.(I've already read these, but they didn't help me - TRYhttp://www.rondebruin.nl/sendmail.htmMIKEhttp://www.skeptic.com/)Thanks very much for any further help

Answer:sending automated emails from excel

I have something similar that i use at work, but i have since re created this in VB6 and therefore cannot remember exactly how i did this in excel, but saying that here is something i would probably do.1) Your due dates are in column D2) Use a free column for todays date '=Today()'3) use another column to calculate the days between today and you due date for example1 D E F
2 30/09/2013 02/09/2013 28
in this example D is my due date, E is todays date, and F is the difference in days between the two, so i would make macro to go through all the records and then send an email when F is for example 10 days. If you wanted to calcualte the dates difference dynamically you can use the DateDiff or even DateAdd function in VBA. You can then use the below code to generate an email which will automatically be sent.Sub Mail_Workbook_1()
' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010.
' This example sends the last saved version of the Activeworkbook object .
Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next
' Change the mail address and subject in the macro before you run it.
With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = "Hello World!"
... Read more

2 more replies
Relevance 56.17%

Hi All.

Hi i have a excel file which has Serial No , Task and date of completion as 3 ccolumns.
I keep on missing the tasks. I heared from somwwhere that we can create automatic reminder in outlook based date picked from excel. I want the same. Example on 1, april, 2010 - if i have to go to my lawer, the in outlook on 1st-Apr-2010 a reminder comes , visit to lawer Mr. XXXXXX.

If any one can help that would be of great help.

Regards,
sam
 

More replies
Relevance 56.17%

HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
 

More replies
Relevance 55.76%

Dear all,

I have the unfortunate task of going through 3 years of emails and renaming them all to include the date the email was sent as a prefix in the YYMMDD format. I was hoping that there might be a method of doing this using either windows, an additional downloadable utility or the 2007 edition of Office. The emails are in one of four formats; either Outlook Express .eml files, Outlook .msg files, or less commonly .txt or .htm files. Whilst I'm aware that there is most likely no one size fits all solution for all of these files types, anything that reduces the time needed to complete this task would be fantastic.

All help would be much appreciated!

Answer:Automated email file renaming

how do you rename the email. I'm looking at outlook right now, and I don't see how you would do this.

4 more replies
Relevance 55.76%

Hello there,

I am trying to work on VB on lists 0f automatic e-mails to send.

At first, I centralized all my third party information on one sheet and succeeded to have a functional formula. That was awesome !

Then, I had to organize it differently. I had to apply the code to several sheets and that's where the nightmare started. It started bugging and after a few cumbersome attempts to fix it, it completely stopped working and saying Ambiguous Name detected. (Something to deal with procedures i think).
This is the code I have:

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

Sub SendEMail()
Dim Email As String, Subj As String
Dim Msg As String, URL As String
Email = Cells(ActiveCell.Row, 10)

Subj = Cells(ActiveCell.Row, 4)

Msg = ""
Msg = Msg & "Dear " & Cells(ActiveCell.Row, 1) & "," & vbCrLf & vbCrLf & "Custom text " & vbCrLf & vbCrLf & Cells(ActiveCell.Row, 13) & vbCrLf & vbCrLf & "Custom text"

'Replace spaces with %20 (hex)
Subj = Application.WorksheetFunction.Substitute(Subj, " ", "%20")
Msg = Application.WorksheetFunction.Substitute(Msg, " ", "%20")

'Replace carriage returns with %0D%0A (hex... Read more

More replies