Computer Support Forum

Set email reminder based on excel

Question: Set email reminder based on excel

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

Relevance 100%
Preferred Solution: Set email reminder based on excel

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

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

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

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

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

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

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

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%

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%

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%

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%

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%

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%

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

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

I have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" then hit send again on the email, can we automate this some how, like a macro that engadges when I open my outlook every morning

Answer:send email from excel based on

This should be in the Office forum here: http://www.computing.net/forum/offi...

2 more replies
Relevance 68.47%

Hi Guys,Currently am working on a Excel VBA to alert me through Outlook email based on the following conditions,I've the deadline dates for each tasks listed in Column 'G'. Now i want the VBA to check this deadline date and if the deadline date is 7 days from today, then it should copy the particular Row data and email the data to my email address.This should be performed everyday automatically, without opening the excel sheet.Am very new to VBA. So,Your help is much appreciated.Cheers,PK

Answer:Excel VBA To Email Row Data Based on Date

re: "This should be performed everyday automatically, without opening the excel sheet."I don't think that Excel or VBA for Excel is not going to be able to do this with opening the file - or at least some file.You can't have a macro running inside a closed file, constantly monitoring itself. Something has to trigger the code and/or update the formula that checks the dates, such as the file being opened or perhaps another open file pulling data from the closed file, etc.I guess you could schedule a windows task to open the file once a day or something similar, but there is going to have to be some "action" that initiates the running of the code.

14 more replies
Relevance 68.47%

Hi,

New here. I dug up a thread that Zack Barresse solved many years ago. I am looking to do the exact same thing. The link to the thread is below. My file is infinitely more complicated than what that user was asking for so I need a bit more help tuning the VBA. Link: http://forums.techguy.org/business-applications/710581-automatic-email-alerts-using-excel.html

Some specifics:

- I am using Outlook not Express
- Excel 2007
- All the functionality is complete for monitoring several live streams of securities data with several trade indicators.
- It is consolidated onto one sheet for manual monitoring (Picture below). Basically takes copious amounts of data and reduces it to just IF and AND functionality for the triggers for easy use from all the other sheets.
- The workbook will be open and running/refreshing on its own 24/7 as it is now.

I am a busy guy, I just need the VBA to automatically email me remotely when any of the 7 currency pairs causes a trigger when I am on the go. I can log trades from an app on my phone.

One other hurdle would be that if say (Using percentages to keep it simple) that a trigger would be if something reached as high as 80% to send the notification email. But where the system refreshes every 60 seconds it shouldn't send another notification each time it remains at or above 80%. Just the once. It may remain there for hours and that is a lot of emails.


Thoughts? and many many thanks in advance.
 

Answer:Excel - Auto Email based on cell value

10 more replies
Relevance 68.06%

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

I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

Thank you so much!
 

Answer:Auto send an email based on date in Excel

Welcome to the board.
I've had to save it as 2003 version but the code works under 2007

See attached my copy of your sheet with the code in ThisWorksheet module.

This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
 

2 more replies
Relevance 68.06%

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

Hi guys,

Really need your assistance ..
Attached is example for my problem.

I only know how to set the parameter for the 'status' (using condiitonal formatting), but i dont know how to create the code in VBA to create emails on certain condition .. I'm not used to VBA, and still learn about it (my head was spinning lately).

So, I wish someone here could help me ..

Regards.
 

Answer:Solved: auto email based on certain condition in excel

16 more replies
Relevance 68.06%

Hy guys

2nd time i am posting stuff for help, and as i was helped before i will again look forward the response.

I have a file of excel, in which i am sending emails to different candidates of admission, with scan letter placed in the same folder by name.

I want to edit this code, which could select attachment based on Column A list adjacent to the email address

I am attaching the file also pasting the code

Sub Test1()
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim SigString As String
Dim Signature As String
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

Set OutMail = OutApp.CreateItem(0)

strbody = "We at Graduate School of Engineering Sciences and Information Technology are extremely pleased to know that you have selected Hamdard University as preferred choice for your graduate/post-graduate Studies. " & vbNewLine & vbNewLine & _
"Hamdard University is a pioneer Higher Education Institute (HEI) of Karachi producing Masters and PhDs in the fields of Engineering, Computer Sciences, Information Technology, Energy and Environment since 19... Read more

Answer:Attachment based on cell value in a excel email macro

anybody ???
 

2 more replies
Relevance 68.06%

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

Hi everybody,

I work in accounting (yeah I know loads of fun )... I have a spreadsheet that I have created to log the cash drops of several cashiers (about 140 currently) that compares it to the readings on our different point of sales systems.

this file has 31 tabs (one for each day of the month) and each cashier has the same row for his/hers information thruout the month. Each day we log how much people are dropping in cash/travelers checks, etc and compare it to what the system is telling us that they should have dropped.

Our policy is that any variance in above $10 (over or short) needs to be investigated by the manager/supervisor of the area in question and the general cashier and income audit manager should also be notified.

What I would like for excel do (not sure if it is possible) is after the general cashier logs the drops and excel tells me if each cashier has a variance above the threashold or not; to send an e-mail with the row containing the cashier's information for that day to supervisor/manager and the accounting folks involved automatically.

I am pretty novice when it comes to VBA and as much as I have been looking online and specially in this forum I haven't been able to come up with a solution to this.

Thank you in advance to anyone that can point me in the right direction.
 

Answer:EXCEL - Email rows to various addresses based on certain criteria

Well I guess nobody has any ideas
 

2 more replies
Relevance 68.06%

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

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

I am working with the attached spreadsheet in Excel 2010 and am trying to figure out how to code certain parameters that will make Excel send myself, my client or other individual an email (with text in body) if certain dates have not been entered into particular cells, or if a cell has exceeded a certain number of days in a particular cell. I have attached a sample spreadsheet and have listed at the bottom 8 points in which I need an email sent, what the trigger is and what the action (email sent to) is.

I just know enough to be very dangerous with Excel but have found that there is a way to code in Excel to send emails which would greatly help my business but I just don't know that much about codes at all.

Can anyone please help me??

Thanks!!
 

Answer:Excel Coding to Send Email based on Cell Entry

Hi, welcome to the forum.

I suggest you do a find in the forum, there are many posts that gao about this and there are many answers, I'm sure there is one that will help yu and of course one of us can help you if you're still stuck
 

2 more replies
Relevance 67.24%

Hi,

I have multiple Excelsheets where in I use it for day today activites & tracking.
I have attached one of the simple one so that I can know the codes for sending mails & I can do it my self for the rest of the workbooks.

There is a sheet(dash board) where in all the details get updated.
When there are any changes to the value in column F, a mail should automatically sent to me giving the detials of the row. The file will be always live in the server.

I am very poor in coding & I need someone to help me in doing this.

Thanks in advance.
Rgds
Ganesh Hassan
 

Answer:Solved: Automatically send email from Excel based on the conditions

8 more replies
Relevance 67.24%

Hi Everyone
I'm needing to automate a process that notifies a group of users to complete specific data on a shared Excel template file. The process is date driven. For example; row 1 has data due on 4/25/2017 by Bob Smith, while row 2 has similar data due on 4/29/2017 by Rose Hill, etc. We are in a Windows 7 environment, Outlook 365 mail clients and recently updated to Office 2016 from 2010.
Anyone have any ideas on how to best approach a solution for via Excel macros?
 

More replies
Relevance 66.42%

Good Afternoon - this is a follow-up to an earlier post that has been closed.

http://forums.techguy.org/business-applications/1090938-emailing-multiple-recipients-excel-based.html

I would like to do something similar.

My Excel sheet has a list of Email addresses in Column A (with duplicate email addresses).
I have several other columns with data that that I would like to have appear in the body of the email in Outlook.

I need to collate each row with the same email address so ONLY 1 email is sent to each recipient.

Is this something easy to do?
I have little to no VBA coding skills

Attached is an Excel mockup of what I am attempting to accomplish.

The 1st tab called "Sample Data" is basically the raw data I want to leverage.
(which I also tried to display below)
Email Address .....Invoice Number .....Date..... .....Dollars
​ [email protected] .............1 ...............7/3/2013 ......$10,000
​ [email protected] ..............2 ...............7/9/2013...... $50,000

[email protected] ..........3 ...............7/9/2013 ......$40,000

[email protected] ............4 ...............7/10/2013 .....$1,000

[email protected] ............5 ...............7/11/2013 .....$3,000
​The 2nd tab called "Body of Email" is an example around how I would like to see the data appear in the email.
Even though [email protected] appears 3 times in the above example, I ONLY want him to receive 1 email that contains 3... Read more

Answer:Emailing multiple recipients from Excel Based off Cell Value Collate to one email

8 more replies
Relevance 66.42%

I need a code that will allow the workbook to be emailed when Column A is populated by certian numbers. The numbers in column A corespond to particular email addreses. This is the code I've been working but it isn't functional.

Sub Email_Out()
If Worksheets("Sheet1").Range("A5:A200") = "190030001" Then
ActiveWorkbook.SendMail Recipients:=("[email protected]")
ElseIf Worksheets("Sheet1").Range("A5:A200") = "190450025" Then
ActiveWorkbook.SendMail Recipients:=("[email protected]")
End If
End Sub

All help is greatly appreciated!
Mikey
 

Answer:Solved: VBA email excel workbook based on cell values using; If Then ElseIf Please he

16 more replies
Relevance 66.42%

Hi This is a follow up to

http://forums.techguy.org/business-...emailing-multiple-recipients-excel-based.html

I would like to be able to do the same

My excel sheet keeps a list of Email addresses on column B (with duplicate email addresses), and their particulars from column C (Item price, purchase date, etc) onwards.

I need the vba to email multiple recipients (those with the "notification" column E field marked as yes) with their purchasing details in it. I need to collate each row with the same email address & marked Yes so that only one email is sent.

eg: email will have in the body

Your order are ready to collect:

row 2 information
row 5 information
row 9 information
It should also prevent multiple emails to the same email address. I would like not to have to change the Notification column to acheve this.

Thank you for your help.
 

Answer:Emailing multiple recipients from Excel Based off Cell Value Collate to one email

6 more replies
Relevance 63.96%

just noticed that my location-based reminders FINALLY have a snooze button that allows me to dismiss the reminder for a period of time instead of the next time i'm at the same location. anyone else notice that yet?

Answer:Cortana Location-based Reminder

oops. i sent that thread w/o logging in. :)

2 more replies
Relevance 61.5%

Existing reminder that I want to edit for a later date or time. I could previously do this and save it, however, the save "box" is missing now.

More replies
Relevance 60.68%

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

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

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

Answer:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

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%

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

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

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

Hi....
Anyone can help me to advice how do i write VBA for auto email reminder for due dates.
I have tried one from internet guidance but it doesn't work.

i want the email reminder to a list of IDs before 60days and it's much helpful if the program can send the email without opening the excel sheet.

please help.
i have attaced the file.

thank you so much.
 

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
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 a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 54.12%

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

Hello.
I have been asked to send warning e-mails to a short list of adresses from an Excel file where reminder dates correspond to the actual date, and I have no clue how to do this with Macroís. Iív tryed to understand how some examples of macros dealing with Excel and e-mails with no success as I still have a lot to learnÖ

Here is my problem : I have a spreadshhet containing company names (col.A) and contract renewal dates (col.D). there are about 80 companies listed. When the actual date corresponds to the reminder date an e-mail containing the company name, a fixed blabla and the reminder date should be send to 3 known e-mail adresses.
Could this be done with an Excel Macro
Iím using Windows 7 32bits, Office 2010 with Outlook as mailing system.

Many thanks in advance.
Robert
 

Answer:Solved: Reminder date in Excel sends an e-mail

16 more replies
Relevance 54.12%

how to set auto reminder when a due date is reached mentioned in excel EVEN WHEN EXCEL IS SAVED AND CLOSED?
 

More replies
Relevance 54.12%

Hi,

I am a beginner to excel VBA/Macro (just know basic excel) but I have a task from my work superior. He has multiple contracts on hand and am checking excel by opening manually for the expiry date. He might forget to check when he's busy. Is there any way for an email to be sent automatically/notification pop up to remind him and 3 other colleagues, 6 months before the contracts' due dates? Thanks!
 

Answer:Email Reminder to be sent 6 months before contract expiry

Yes this is very possible, how is your workbook laid out, in fact it would be better if you upload a copy REMOVING all sensitive information, or replacing that information with dummy data. Then we can have fun coding it.
 

1 more replies
Relevance 54.12%

which one is best , and anonymous..I found this list ..click here any ideas one which one might be best..?

Answer:simple free email reminder service

for regular reminders-click here

2 more replies
Relevance 53.71%

Hello,

I was able to successfully apply Hans' module and have the spreadsheet send an email when it was opened if something was out of the calibration date.

My question is now if it is possible to have it send 2 weeks in advance, and then again in 1 week later. I know that because the cell will be occupied that it was initially sent, it will not read it again for another send. Is there a way to automatically clear a column so that it just sends an email every time its opened within that range?

Finally, where do I add the column for a CC email?
Code:
Option Explicit

Public 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
Dim ws As Worksheet
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Set ws = Sheets("Master Equipment LIST")
Sheets(1).Select
lRow = WorksheetFunction.Max(3, ws.Cells(Rows.Count, "K").End(xlUp).Row)
If ws.Cells(lRow, "K").Value = "" Then Exit Sub
For i = 2 To lRow
toDate = Replace(Cells(i, "K"), ".", "/")
Debug.Print WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value)
If WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value) <= 14 And Len(Trim(ws.Cells(i, "M").Value)) = 0 Then
' If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 30 Then
t... Read more

More replies
Relevance 51.66%

Can anyone let me know if any software exists, that will allow me to get notification that email I send from AOL, has been read by the recipient please?

Answer:Receipt for email sent from AOL to web based email

Aol will notify receipt of mail by other Aol members. This is a programmable option, though i can't find it at the moment!I doubt if any software exists which will show that a particular email has been opened whatever the ISP or whoever receives it. (Except for dialler viruses and malware)In a negative sort of way the obvious comment arrives when the email is not deliverable because of "Fatal" errors in the address.

1 more replies
Relevance 50.02%

I have created an excel sheet which I use to track all of the documents our people have with expiration dates on them (clearance badges, licenses, etc).

It's a fairly simply sheet with the following headers:
Column A as the Document Holder (in the format of Doe, John)
Column B as the Document Type (Flight Line Badge, CPR Certification, etc)
Column C as the Expiration Date (in MM/DD/YYYY Format)
Column D as the "Expired?" collumn with conditional formatting and a "YES" or "No" output from an IF formula
Column E as an "Expires in" counter with

Code:
=((TODAY()-C2)*-1)&" Days"
as an example output
and Column F as a notifier in the event I have 60 days or less before something expires. The formula used is:

Code:
=IF((AND((TODAY()-C2)*-1<61,(TODAY()-C2)*-1>0)),"EXPIRING SOON"," ")
wherein I used the "And" function to keep things that were already expired from saying that they were "Expiring soon".

So far so good, right? Well, what I'd like to do is figure out a way to click a button once a week or so, and send an email to not only the Document Holder, but to carbon copy the HR department as well.

The way this form currently works is that when Columns A and B use Data Validation against two other worksheets in the same workbook: Associates and Documents, respectively.

I understand that in order to make my macro goals a reality, I will likely have to add a Column G ... Read more

Answer:Excel-Based Notifications

11 more replies
Relevance 50.02%

Hi everyone,I own a small business, which at the moment is based in a small shop in Stoke-on-Trent. The details of all of my stock is in an excel spreadsheet. This consists of stockcode, stockname, price, and category. I now wish to expand to an online shop. I have some understanding of the rudiments of web design etc... but was wondering, is there any way of using my excel spreadsheet, which contains all of my stock details, to "supply" the website I am designing in, say, Dreamweaver with the relevant details?Is this at all possible? Thanks for any help,Stuart

Answer:Excel-based Website?

Yes, you can run a site off an Excel document, but it's rather involved and has its own share of problems.I'd almost always argue in favour of transposing the Excel data into an Access database. After that point you can create ASP pages which can read from and write to the databse.You will need to host the site on Windows servers with full ASP support and the ability to upload at least one Access database.Access is fine for relatively small sites but large web applications are always better off using MS SQL or MySQL as the underlying database.Unless you start getting hundreds of concurrent hits though, Access is fine and you can migrate (upsize) to MS SQL later if and when the need arises.1&1 click here offer one of the best value Windows hosting accounts I know of and you get full FrontPage Server Extension, ASP, .NET and Access database support, among other things. You can also get the latest copy of FrontPage if you take out a Windows hosted business plan and their control panel is easy to use.Getting started in dynamic web design is the one area of web authoring that usually brings things crashing down like a house of cards. At the end of the day, anyone can use a WYSIWYG editor to drop elements onto a web page and produce something like a website. The same cannot be said for dynamic sites though, which depend entirely on a fundamental understanding of databases, how and why they work, and how to hook your pages into them without compromising performance and (more importa... Read more

10 more replies
Relevance 50.02%

Problem:

Use AOL on-line website interface for Email.

Working on a Mac with OS X 10.8.5 (although since my AOL access is on their web interface, I could access with other machines)

I tend to access through Firefox, but I could also use a different browser if that would help.

Need to provide copies of thousands of my AOL emails due to being deposed as a witness in a business litigation case.

Question:

How can I most efficiently copy the 1000+ emails from the AOL web-based storage to something the legal types will be able to print and read?

I'd prefer not to give a 3rd party access to my email and I'd also prefer not to have to PDF print every email, especially since I've just been roped in as a witness.

Any more-clever-than-me folks have any thoughts on how to copy a large number of emails off the AOL online site?

Thanks in advance.

Answer:AOL web-based email help

First download to a client i.e. TBird. If TBird which is easier than Outlook, follow these instructions: How to Copy Thunderbird Email to a Flash Drive | eHow
They'll be in text format so receiver won't even need TBird.

2 more replies
Relevance 50.02%
Question: web-based email

Hi GuysIs there a anti virus program for scanning web-based emails . Thanks

Answer:web-based email

Hello Mate this may be of interest click hereCheers Kev

1 more replies
Relevance 50.02%
Question: Web -based email

Hi Guys. Is there a anti virus email program for web based email such as "Yahoo or Hotmail". I run NAV 2002 at the moment to scan outlook express, my os is XP home. Thanks

More replies
Relevance 50.02%
Question: Web Based Email

I'm attempting to create a "Contact Page" for my web site. With it, I'm trying to send IP address with the email that they send.

Below listed is the code that I've scored from various places, but I for one, don't know much about php, and two, can't seem to figure this one out... any help would be appreciated.

on my site, I'll load the file contactpage.php - and in this contactpage.php I currently have:
PHP:

<?     $ipnamex getenv ("REMOTE_ADDR"); 

         
$ipsystem gethostbyaddr($ipnamex);

         
$ipaddr $ipnamex;

 
?>

<html>

<b... Read more

Answer:Web Based Email

16 more replies
Relevance 50.02%

I want to register with a non web based email that will work with windows mail. my computer is vista. when i want to send a file my email accounts are web based and do not work with windows mail- which puts the files straight into the email and I don't know how to send them.

Answer:non-web based email

Call your Internet Service provider...

1 more replies
Relevance 49.61%

I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.
 

Answer:Excel/Highlight Row Based on Date

use conditional format
add a formula

=cell with the date = today()+1
that will be true if the date

just to make sure we understand

today() is 7th August
the date in the cell is 8th august
so you want it highlighted

so cell = 8th
today + 1 = 8th
it highlights

now to highlight the row
use a $ on the cell that has the date and apply to the whole row

so if the date is in column C and say row 5

then
$C5 = today()+1

in the conditional format formula and apply to
$A$5:$Z$5
or whatever column you need

a sample spreadsheet would be useful , you can attach here
 

1 more replies
Relevance 49.61%

Greetings, Given the following columns:Column A: Column I Column J Column PProvider ID Units Amounts Total recovery amount I wold like to enter a formula on Column P to calculate the following: 1. Group Provider IDs and sum ?Amounts? (column J) 2. Group Provider IDs and sum ?Units? (column I)3. Sum of ?Amounts?/Sum of ?Units? 4. Subtract 24 from total units (step #2 above) 5. Finally, multiply (step #3) by (step # 4) above Once I obtained totals for each provider, I would like to display the grand total for all.Any ideas?Also, can you please advise how I can attach a sample? TIA,

Answer:Excel formula to calculate based on IDs

You can check for "Total Units" that are less than 24 by adding an IF function. This will eliminate negative Recovery values.=IF(SUM(I2:I4)<24,"",(SUM(I2:I4)-24)*(SUM(J2:J4)/SUM(I2:I4)))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 49.61%

I am trying to get an annualized sales figure based on YTD sales. I want this to be linked to a today() function so that the spreadsheet only includes figures from today's date or before when calculating the annualized total. I have a table with months and corresponding totals shown below each month (starting in April). And thought I could use a formula including sumif that would tally and annualize all numbers with corresponding months less than or equal to the month from today's date.





Something along the lines of:
=SUMIF(B8:M8,"<=H3",(B10:M10))

B8:M8 was the row of months (April-Mar)
B10-M10 was the row of sales figures from those months
H3 was a "text" formula, extracting the month from a corresponding "today()" formula.

For some reason this only seemed to take the figure from the first month (April). Not sure where I am going wrong?

Any help is appreciated.
 

More replies
Relevance 49.61%

HI EVERYBODY,

FRIENDS WE ARE DOING A PROJECT WERE WE HAVE AN AUDIT TRAIL OVER THE CHANGES MADE INTO AN EXCEL-FILE DOCUMENT.

FIRST WE HAVE A FEW RECORDS IN FORM OF .XLS FILES .ANY USER CAN OPEN AND READ THESE FILES BUT IF HE TRIES TO CHANGES IT THE NAME OF USER ALONG WITH OLD AND NEW VALUES WILL BE SAVED IN AUDIT TRAIL.

WE ARE ALSO TOWARDS PROVIDING E-SIGNATUTE FUNCTIONALITY TO IT.

SO , NOW I HAVE TWO BASIC QUERIES.

1.> as i'll be using all of the basic ms-excel functionality + our own customized requirements of our client, then what are we supposed to use as a base of project.i:e which option should i select to proceed

a.) some how do modifications to ms-excel like 3rd party component who gave us the rights of customization as it will be quite diff to do it from scratch.

b.) built our own new application including the excel part from scratch

c) any other option which i dont know.
2.> second query is that the client's requirement is to make this application web-based i:e to run in IExplorer and uptill now we have used asp.net so in my openion it seems that it will be benificial if we make it a desktop based pure vb.net application or is there any way out to do it efficently is asp.net ?
means what exactly will be the pros and cons of both approaches.

--------------------------------------------------------------------------

hopes that my query is clear to you people ,otherwise i can provide you with more explaination.
i am eagerly waiting for respon... Read more

More replies
Relevance 49.61%

Like the Word 0 Day attack, so far this new threat is low risk and not prevelant in the wild. Still, until AV vendors have this covered all users should be very careful and not launch any EXCEL spreadsheets they may find in unexpected email messages. Mdropper.J - Zero Day Excel based Exploithttp://blogs.technet.com/msrc/archive/2006/06/16/436174.aspxhttp://secunia.com/advisories/20686/http://www.frsirt.com/english/advisories/2006/2361Mdropper.J - Links related to New Trojan Horse http://www.frsirt.com/english/virus/2006/04533http://www.symantec.com/avcenter/venc/data...mdropper.j.htmlHere's what we know: In order for this attack to be carried out, a user must first open a malicious Excel document that is sent as an email attachment or otherwise provided to them by an attacker. (note that opening it out of email will prompt you to be careful about opening the attachment) So remember to be very careful opening unsolicited attachments from both known and unknown sources.Technical Description: A vulnerability has been identified in Microsoft Excel, which could be exploited by attackers to take complete control of an affected system. This flaw is due to an unspecified error when processing a specially crafted document, which could be exploited by attackers to execute arbitrary commands by convincing a user to open a malicious file.Zero Day Excel based Exploit: This 0day vulnerability is currently being exploited in the wild by Trojan.Mdropper.JAffected Products: Microsoft Ex... Read more

More replies
Relevance 49.61%

Hi,I have an issue in evaluating actual project spend for people working on the project.The cost is evaluated by DAY RATE x FULL TIME EQUIVALENT (FTE).The FTE figure is used for evaluation of cost and also for the evaluation of the additional effort used over normal hours worked.My issue is that I need to record where resources work over 1 FTE (ie. over their allotted 7 hours a day) however when evaluating the cost if greater than 1 is entered I need to evaluate it as 1EG.ColA -------------- ColBDAY RATE------ FTE150 ---------------- 0.9200 ---------------- 0.8220 ---------------- 1.2So I need SUMPRODUCT to evaluate as (150*.9)+(200*.8)+(220*1) {rather than 220*1.2}I feel I need to use sum product as I also have a mechanism in place where a user can add a further resource line (hence I can simply use (150*.9)+(200*.8)+(220*1) Please help

Answer:Excel Sumproduct based on IF criteria

Why not just make it easy and do the math yourself with an IF statement added in the middle. So for your example, you would use this formula in the final cell where you want the total to be. =(A2*IF(B2>1, 1,B2))+(A3*IF(B3>1, 1, B3))+(A4*IF(B4>1, 1, B4))By adding the IF statements in the formula, you are letting it decide if it should use the value that is there or substitute a 1 if it is over 1. Obviously, this formula will eventually grow too large if used to calculate a lot of cells, so it can either be split up by adding an extra hidden column to the sheet to calculate out each individual row and then SUM the resulting values, or it can be converted into a formula using VB. Please let me know if you have any questions or need more assistance. -----IT Desktop & Network Consultant - MOS Master Certified, MCP, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +::geek::

2 more replies
Relevance 49.61%

Hi,

I have a dashboard that I wish to put on a network folder for easy access to everyone. However, the VBA code in that uses the absolute path to create a connection string. It works fine with something like "c:\<path>". However, when I change the same reference to the network folder path that starts with "\\<network folder>" this does not work. I am using the following code:

This Works:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=C:\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"

This Does Not Work:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"

Can somebody please help me with this?

Thanks in advance,
Raoul
 

More replies
Relevance 49.61%

Hello,I have a similar problem and tried adapting this with no luck. If there is a 1 in column F, I need the full row to repeat, including the functions within in. Here's an example: AM33SAS-F.bmp M SAS 33 0 0 AF05SAS-F.bmp F SAS 05 1 AF05SAS-F.bmp <-- This row must repeat.I need info on how to input this as well. I have been trying to create a Macro, but I'm not sure I did it properly. The videos online don't help. With the above script, I have received errors for the name I gave the Macro, End Sub Expected, and even when I don't get an error nothing happens. I need the macro to apply to specific sheets. Please help!Here is my adapted script: Private Sub Worksheet_Change(ByVal Target As Range)On Error GoTo errHnd'Don't do anything if more than one cell has been changed If Target.Cells.Count > 1 Then Exit Sub'Determine if the changed cell is in Column F and is a 1 If Target.Column = 6 Then If Target = "1" Then'Disable events so code doesn't fire again when row is inserted Application.EnableEvents = False'Copy & Insert changed Row, Clear dotted lines Target.EntireRow.Copy Range("A" & Target.Row + 1).Insert Shift:=xlDown Application.CutCopyMode = False End If End IferrHnd:'Re-enable event Application.EnableEvents = TrueEnd Sub

Answer:Macro to insert a row based on a value in Excel? Please help

Just so you know that you aren't being ignored, I've read your post and will work on something a bid later. I won't have access to Excel until later today.In the the meantime...1 - The code you posted is known as an "event macro". It is designed to fire when an event occurs, in this case, a change to the spreadsheet. Specifically, it does its job as soon as a 1 is manually entered in Column F by the user.I am assuming that you want to loop through an existing data set and copy each line where a 1 is already present in Column F. Please confirm this.2 - Please click on the following line and read the instructions on how to post VBA code in this forum. Thanks.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 49.61%

Is it possible to format cells to a certain colour if the date given in an adjacent cell is a Monday? I have a table of values occuring only on weekdays, and would like every Monday to be highlighted to mark the beginning of the week. The dates are currently in Short Date format (dd/mm/yyyy).
 

Answer:Excel: conditional formatting based on the Day

Assuming the actual dates are in column A, try this for your conditional formatting formula:

=WEEKDAY($A1,2)=1
 

2 more replies
Relevance 49.61%

HI EVERYBODY,

FRIENDS WE ARE DOING A PROJECT WERE WE HAVE AN AUDIT TRAIL OVER THE CHANGES MADE INTO AN EXCEL-FILE DOCUMENT.

FIRST WE HAVE A FEW RECORDS IN FORM OF .XLS FILES .ANY USER CAN OPEN AND READ THESE FILES BUT IF HE TRIES TO CHANGES IT THE NAME OF USER ALONG WITH OLD AND NEW VALUES WILL BE SAVED IN AUDIT TRAIL.

WE ARE ALSO TOWARDS PROVIDING E-SIGNATUTE FUNCTIONALITY TO IT.

SO , NOW I HAVE TWO BASIC QUERIES.

1.> as i'll be using all of the basic ms-excel functionality + our own customized requirements of our client, then what are we supposed to use as a base of project.i:e which option should i select to proceed

a.) some how do modifications to ms-excel like 3rd party component who gave us the rights of customization as it will be quite diff to do it from scratch.

b.) built our own new application including the excel part from scratch

c) any other option which i dont know.
2.> second query is that the client's requirement is to make this application web-based i:e to run in IExplorer and uptill now we have used asp.net so in my openion it seems that it will be benificial if we make it a desktop based pure vb.net application or is there any way out to do it efficently is asp.net ?
means what exactly will be the pros and cons of both approaches.

--------------------------------------------------------------------------

hopes that my query is clear to you people ,otherwise i can provide you with more explaination.
i am eagerly waiting for respon... Read more

More replies
Relevance 49.61%

Help me with this.I want to total all score that has Cell A=STUD but Cell B=A, and also A=MAN but B=C. can you give me the formula for this I really appreciate your help guys. A B C STUD A 2MAN C 3STUD A 5STUD A 10

Answer:Excel Formulas to Sum Based On Conditions

To get Total of STUD A=SUMIF(A1:A100,"=STUD",C1:C100)To get Total of MAN C=SUMIF(A1:A100,"=MAN",C1:C100)Change A1:A100 and C1:C100 as per your data.

5 more replies
Relevance 49.61%

I have the following formula im having trouble with Im hoping someone can help me out A B D Date 02/30/2010 03/31/2010 Pop $23.00 $42.00 Candy $15.00 $12.00 Fuel $37.00 $25.00there would be one colum created for each day, and I would need a formula that says look up each column for the month of March and add the candy. Then look up each column for the month of february and add the candy Any help would be appreciated

Answer:Excel: Add Data Based On Month

Would it not be simpler if you reversed it:Date Pop Candy Fuel

3/26/2010 $179.80 $1.75 $314.65
3/27/2010 $193.70 $1.85 $358.35
3/28/2010 $89.10 $1.98 $176.42
3/29/2010 $94.30 $1.87 $176.34
3/30/2010 $139.23 $1.75 $152.40
3/31/2010 $84.20 $1.81 $152.40

March Total $780.33 $11.01 $1,330.56

4/1/2010 $179.80 $1.75 $314.65
4/2/2010 $193.70 $1.85 $358.35
4/3/2010 $89.10 $1.98 $176.42
4/4/2010 $94.30 $1.87 $176.34
Then you can total across and get total of all expenditures for March.You can see each months total individually and you can simply "total the totals" for your yearly figures.You can of course do the same thing going across the columns,simply add a totals column at the end of every month, but that would be 365 daily columns, plus an additional 12 monthly columns and probably a yearly column.That's an awful lot of columns to scroll over to.I think doing in down rows makes for a simpler solution.MIKEhttp://www.skeptic.com/

7 more replies
Relevance 49.61%

HiI have in column B three different types of data marked as S M and PD, and some other taht i don't need to calculate. in the next column (C) I have the numbers (35, 23 etc) Is it possible to create the formula that adds up the total form C column if anything in a B column equals S, then total from C column if anything in B column = M and last total from C if B column = PD?

Answer:excel formula for Sum based on conditions

The =SUMIF function is what your looking for:B C
s 35
m 23
pd 12
s 35
m 23
pd 12
In Cell C7 but the formula: =SUMIF(B1:B6,"s",C1:C6)and you will get the sum of all the S letters,In Cell C8 put the formula: =SUMIF(B1:B6,"m",C1:C6)and you will get the sum of all the M letters.You should be able to figure out the rest.MIKEhttp://www.skeptic.com/

8 more replies
Relevance 49.61%

MACHINE Machine Delay%SNLS 10%DNLS 10%2T O/L 6%3T O/L 6%5T O/L 7.5%Feedo 7.5%Now i want any logic or formula by which if i type SNLS in a cell then it automatically assign 10% to adjacent cell. Similarly if i type feedo in a cell it automatically assign 7.5% to adjacent cell

Answer:Excel: Assign value based on input

try using=IF(A1="SNLS",10%,IF(E15="Freedo",7.5%))Where A1 here is the cell which contains SNLS, freedo, etc. If you want all the values you mentioned then use:=IF(A1="SNLS",10%,IF(E15="Freedo",7.5%,IF(E15="DNLS",10%,IF(E15="2T O/L",6%,IF(E15="3T O/L",6%,IF(E15="5T O/L",7.5%))))))

3 more replies