Computer Support Forum

Auto Email reminder from Excel

Question: Auto Email reminder from Excel

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

Relevance 100%
Preferred Solution: Auto Email reminder from 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: 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 97.99%

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

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

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

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

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

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

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

More replies
Relevance 77.9%

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

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%

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%

Hello there,

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

Thanks for your time.

Tim
 

More replies
Relevance 75.03%

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

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

thanks
 

Answer:Set email reminder base on Excel

16 more replies
Relevance 75.03%

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%

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

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%

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

Hi lovely people!

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

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

Cheers!
 

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

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

1 more replies
Relevance 73.39%

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

More replies
Relevance 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 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%

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

hello,
i am trying to sent out an automatic email anytime the workbook has been changed and for example 3 days have passed from a certain date on the worksheet. this would have to be applied to close to a hundred rows per sheet and would be sent to outlook 2007. not express or anything. wondering if it would require multiple VBA codes or not.
i have looked on the Ron site and many postings but i just found out what a macro was and would love to learn how to write VBA but dont have the time. looking to try and solve this. also need to know if the computer im working on has to have outlook or if i can do it from one that doesnt.
Have an example and any details for further assistance just ask. any help would be greatly appreciated thank you.
 

Answer:Auto email using excel

16 more replies
Relevance 65.19%

Firstly i would like to say hi to everyone and thanks in advance for any advice / help.

Here is my problem...

I have a spreadsheet and it contains a list of our employees and when any of their work related certificates expire. What i would like to do is create a script??? or something that will run and send an email to a selected list of people informing them that a certificate is about to expire.

The spreadsheet is excel format and the email software my work uses is Groupwise.

Also something to note would be that there may be multiple people who have expiring certificates at the same time, would it be possible to send just one email or would individual emails be the only way to go.

I have attached a very simple spreadsheet so you can get a better idea of what i mean.

Once again, thanks guy for any help you can provide.
 

Answer:Auto Email from Excel

why oh why do spamers exist
 

2 more replies
Relevance 65.19%

Hi there

can someone help me trigger auto email from the attached excel sheet ?

The email should be triggered upon the 'status' with corresponding message from 'remarks' column
 

More replies
Relevance 64.37%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
Treasurer
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 redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.
Thanks!
 

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample
 

2 more replies
Relevance 64.37%

Hi I am trying to set up a Client data base and I would like to be able to email everyone in the company when a change has been made to columns B,D,E, and F. I plan on having different tabs for each company and when I update the companies folder and change one of those four columns, Iím looking for it to send out an email alert saying "CompanyX Contact Manager Client Folder Has Been Updated".

I have been trying my best to figure it out with info I found on here but I am not very good with Code and any help will be much appreciated
 

Answer:Excel Auto Email Code ?

16 more replies
Relevance 64.37%

HI All,

Can any one help me on this.

I want to auto send email from file whwnever a cell value changed.

In attached excel file if the value of cell "C" get changed to yes then excel should automatically send email to the addreess mentioned the column D.

Help on this .

shishir kumar
 

Answer:Excel to auto send email

Hi there, welcome to the forum,
There are quite a lot of postings with similar questions.
Have you checked this? You can search for then and I'm sure that the solution is there for you.
Some minoor editting may be needed but it will work
 

1 more replies
Relevance 63.55%

Hi, I have download a template from http://www.rondebruin.nl/sendmail.htm and make some modification to create a tracking program for own use. Now, I would like to add in some features to my tracking program which hope it will serve better. I have few questions here which would like to seek for the expert support.

Refer to the attachment:
1. How could I make the email to send out the OPEN and OVERDUE items only(excluded the closed items)?
2. I have set the conditional format, it work in the Excel but not work in the email. How could I solve this (It's just shown differently)?

Hope to hear from you soon.
Thanks in advance.

Regards
Ykit
P/S : I am using Excel 2007 and Outlook 2007.
 

Answer:Solved: Excel - Auto Email Problem

16 more replies
Relevance 63.55%

Firstly Hi,
I'm Hodge and this is my first post on this forum, please (HELP)

I have been looking around the various forum's trying to figure this out myself but with little success. There are many variants of this problem throughout these forums with many solutions, but none of which i've been able to adapt or use.

I basically run a diving team with 27+ divers and have various spread sheets to manage the team, from equipment servicing to personnel run out dates. I have been trying to find/create a Macro that will automatically send me an email, with Cc's option, when cells in column M & O turn yellow or red. Then copy all the data within that row and email the address in column P as an attachment. I have looked at Ron de Bruin's code, and tried to adapt it without success. Once I have the correct code, I believe i will be able to adapt it to most, if not all of my spreadsheets.

Hopefully someone has used this type of code before for the same reasons, Sorry must mention that I'm working on MS Office For Mac 2011, but don't think the process is much different. I don't really know much about VBA, so any help will be welcomed.

I've attached one of my spreadsheets just incase.

Thanks in advance for any help you may be able to offer.

Hodgey
 

Answer:Solved: Auto Generated Email in Excel

16 more replies
Relevance 63.55%

Hello,I sort of got stuck with a very tedious Excel tracker that tracks when people are due for their vaccinations.I know that there are ways to set up formulas in Excel 2007 but I am pretty ignorant in the whole process. I humbly request your help.Here is a gist of my Excel tracker:Column A=Name | Column B=Job Title | Column C=Due DateAnd then the rows fill in accordingly.So, let's say I had this:John Smith | Janitor | 09/15/2010Could I somehow synch those three rows up with my Outlook contacts list and send a formatted email to them? Could I also set it up to CC me?I would want something like, " Hello, if you are seeing this then you are due for your annual vaccination. Please complete your vaccination as soon as possible. Thank you."Thanks for your help.

Answer:Excel Due date tracker-- Auto email when due?

Hi,I can offer some help with formulas.If you have the following arrangement A B C D E F
1 Name Position Vacc. Due Status Rem. sent Vacc. Date
2 Smith J Janitor 15-Sep-10 Due 15-Sep-10
3 Smith K Clerk 10-Sep-10 Done 10-Sep-10 12-Sep-10
You can start by getting a warning when a vaccination is due.In Cell D2 enter this formula:=IF(C2-TODAY()<8,IF(F2="","Due","Done"),"")This tests to see if the due date is 1 week or less away from today's date, using "IF date difference is less than 8 (days)" : IF(C2-TODAY()<8For a longer warning increase the 8 in the formulaThe formula then uses a second IF to see if the vaccination date cell has been completed : IF(F2="","Due","Done"). This returns "Due" if there is nothing in the vaccination date cell, else it returns done.To avoid "Due" showing up when there is no date in cell C2 you can add an extra test for an empty cell:=IF(C2="","",IF(C2-TODAY()<8,IF(F2="","Due","Done"),""))Now to improve the visibility of vaccinations due, you can use 'Conditional formtting' which changes the appearance of a cell based on values in that (or other) cells.Select cell D2.From the Ribbon select Home - Styles - Conditional Formatting, From the drop down select 'Manage Rules' and select 'New Rule'In the dialog box select the last item in the list 'Use a formula to determine which cells to format'Enter this formula in the box =IF(D2="Due",TRUE,FALSE)Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and fa... Read more

2 more replies
Relevance 63.55%

Hello folks. Just a general opinion required at the moment, please. I might need to create something to monitor due delivery dates against actual delivery dates. It's pretty easy to use an Excel wbook and conditional formatting to highlight late deliveries, but what I'd like is an automated email sent to a couple of relevant people as soon as an item becomes late. That also might not sound too hard, but what I think might be a problem, is this. Is there a way for this to happen even if the program is not currently open and running? And would this sort of thing be easier to achive in Access or Excel? (Assuming it is possible at all)Thanks

Answer:Excel or Access to auto send email

If the program is not running, then that's it. The only thing I can suggest is that you run the program automatically using Schduled Tasks.

5 more replies
Relevance 63.55%

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

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

Hello Everyone,

I am a beginner at using vba and I am trying to use excel to send an email automatically depending on a past due date. I have a an excel sheet that has over 200 companies and we require an annual report but everyone report is due at a different date. I am using conditional formating to change the color of the text depending on how long it has been since we have received the last report. If the last report is 366 days since it has been submitted then I would like an automatic email to be sent.
For conditional formatting i used this "=(TODAY()-365)"

For email i am using;

Sub Send_Email_Using_VBA()
Dim Email_Subject, Email_Send_From, Email_Send_To, _
Email_Cc, Email_Bcc, Email_Body As String
Dim Mail_Object, Mail_Single As Variant
Email_Subject = "Trying to send email using VBA"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Cc = "[email protected]"
Email_Bcc = ""
Email_Body = "Your annual report is Due"
On Error GoTo debugs
Set Mail_Object = CreateObject("Outlook.Application")
Set Mail_Single = Mail_Object.CreateItem(0)
With Mail_Single
.Subject = Email_Subject
.To = Email_Send_To
.cc = Email_Cc
.BCC = Email_Bcc
.Body = Email_Body
.send
End With
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub

If possible i would like to use an email template that excel would place the values specific to the co... Read more

Answer:Excel - Trigger Auto Email Depending on Date

Hi welcome to the forum.

You already have the send_email_using_vba, weel you will need something that checks all the cells where the due date is x days old and call this macro

Sub CheckSomething()

<< here you will have to put the code that checks each rows in the
<< date column and if the condition is met then call the send email macro

End Sub

Since I have no idea of your sheet's layout you will have to do your own homework

I suggest you also tell us what version of Excel you're using,
 

1 more replies
Relevance 63.14%

Hi Guys,

We create basic spreadsheets to keep track of tasks and reviews. Often spreadsheets have different formats with one thing in common. Each will have a due date.

I would like be able to create Macro / VBA to send email and/or task for due dates in multiple excel sheets.
Using MS EXCEL2007 and OUTLOOK 2007
Reminder to be sent at trigger event dates 14 days,7 days, 2 days before due and every day overdue
Due dates could get color coded as they approached deadline. For e.g Over 14 days (nil), 14 days (green), 7 Days (orange), 2 days/ overdue (Red).
Due dates could be always put in column A for example for simplicity and consistency if necessary or perhaps it could work of Column heading (DATE DUE).
Also for simplicity emails would only need to go to 2 people. From there we can forward to relevant people after being aware of task ourselves.
When multiple trigger events occur within same Spreadsheet, Have the one email rather than 20 if twenty occur on same day. Different spreadsheets emails are fine.
A check that if email has been sent it will not send another email till next date trigger event.
A 'Send Email' button for all trigger events and another Send selected email' button for one or more selected rows only.
Text in subject line email could be Excel file name
Text in body of email would include Excel file name and Title row and trigger event row.
Unfortunately i have limited experience with Macro's / VBA. Have checked forum... Read more

Answer:General auto-email deadlines: excel - Outlook

There are quiet a lot of posts with similar quetions, maybe you should take a look at these.
When you open your thread you can see the list of 'similar threads' below.
 

1 more replies
Relevance 63.14%

Hello Everyone,

I am a beginner at using vba and I am trying to use excel to send an email automatically before 5 days of due date. I have a an excel sheet of bank loan repayment but every loan due at a different date.

If possible i would like to use an email template that excel would place the values specific payment details and their due date and then send the email to the email address on the specific cell.

I have attached my excel sheet format for your referance.
Thank you so much in advanced

Regards,
Nilesh Jagtap
 

Answer:Excel - Trigger Auto Email Depending on Due Date

Welcome to TSG niljag!

Working on one of these right now at this TSG thread . Practice1.xls in Post #4 is lastest. See if you can adapt to similar. I didn't look at your attachment.

There are many of these(excel emailers) in TSG. Search "excel email" and find one you like. When you get to an issue let us know and we'll try and help.
 

1 more replies
Relevance 63.14%

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

Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.

Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.

Can someone suggest a better way of handling this that is not time consuming?

Thanks In advance!
 

Answer:MS Access 2007 - Macro > Excel > Auto Email

Access can open Outlook and send an attachment to mutiple recipients either as a list or as individual emails.
So are the attachments all the same for the recipients?
 

1 more replies
Relevance 62.32%

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!
 

Answer:Solved: Outlook Email to Auto-Fill Excel spreadsheet

8 more replies
Relevance 61.5%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
 

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")

Regards,
Rollin
 

2 more replies
Relevance 57.81%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

More replies
Relevance 57.81%

I had made one excel to send automatic due date reminder mails via Groupwise (made with the help of your forums only).
The problem I am facing is as below:
[Also note, problem is not whether Groupwise or Outlook, problem is its generating multiple emails for each due item]

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.

Right now its sending 3 mails as:

Mail 1: Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
Sent at 17-Sep-13 11:11:04 AM

Mail 3: Please take notice of the following expiration date(s):
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.
-Equipment C Job cccccc OVERDUE : 19-May-13 -121 days.
Sent at 17-Sep-13 11:11:04 AM

And the ones not due, going blank, i.e: the mail body (Mail 2) text reads:
"Please take notice of the following expiration date(s):
Sent at 17-Sep-13 11:11:04 AM"

What I wanted was a single mail with following in the mail body (Example):

" Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.... Read more

Answer:Request Help: Further study on Auto-mail for due date reminder

10 more replies
Relevance 57.81%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

Answer:How to send auto reminder in outlook if due date arrived?

Can you clarify something pleaseAre you looking to have a number of dates in Excel, which when reached/passed Excel is to create an email via Outllook and send it to someone?Can you provide an example of how your workbook is laid out

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

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%

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

I attach the following

I need your expert solution

Any help appreciated and thank you.
 

More replies
Relevance 55.76%

Hy there,

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

Thanks.
 

More replies
Relevance 55.76%

Hey Guys,

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

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

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

Will be gratefull! for your help.
Thanks.
 

More replies
Relevance 55.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, 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%

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

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

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

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

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

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

Im wondering if it is possible to do this before i start trying...

I recieve an email containing an excel sheet containing several peices of info such as:
Name
Surname
ID
Etc Etc... Now when i open this.. i need the information posted into specified columns in a new excel document where it will have
NAME | SURNAME | ID |
-------------------------------------------
STEVE NORTH 01874
Any help given appreciated.
 

Answer:Excel - Auto export data into specified excel sheet

6 more replies
Relevance 50.84%

In excel 2010, I entered "=HYPERLINK(VLOOKUP(B3,CTO_DB!A1:B1001,2,0),B3)". How can I make it auto open the file if hyperlink is exist? Thanks

Answer:Auto open word, excel and pdf file in excel

It is a bit complicated, using LOOKUP with HYPERLINK,see here for an explanationhttps://stackoverflow.com/questions...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 50.84%

I have had to reinstall pc due to it going at a crawl!!

After installing Outlook 2002, I can not get Outlook to auto fill the email address field when I start to type an email address in it.

The address book is there and in tacked after copying the outlook.pst file back to its original location after install.

How do I get Outlook to autofill?

Also when I click the 'TO' button in the new email window, it says that there is no address book!
but when I click the address book icon in the main Outlook window there are email address there?!

Any ideas how I can get this to work correctly again.

Answer:reinstalled pc, now create email in Outlook 2002 does not auto fill email address like before

When you did the re-install, did you erase/format the hard drive before the re-install? If you did and did not save the Outlook auto fill file, then the all the auto fills you had are gone. Did you import the pst file into outlook?

1 more replies
Relevance 50.84%

hi there,,when i go to enter my email address in firefox the pop up address is spelled wrong,,,how can i change it,without losing all my auto complete forms.
i am using windows xp home edition..
thanks..
 

Answer:Solved: wrong email spelling in auto complete email address

Delete Firefox auto-complete entries

There is also an add on for firefox that allows you to manage autocomplete

Available features include:

* matching against bookmark addresses
* matching against page titles and bookmark names
* matching anywhere in the address, not just the beginning
* changing the sorting criterion to alphabetical by address or title, most frequently visited, most recently visited, or top-level pages first
* completing the best match inline
* temporarily or permanently disabling the suggestion popup
* excluding local pages and pages containing search results
* swapping the address and title columns on the suggestion popup
* highlighting the column where a match was found
* fine-tuning the popup appearance by hiding page titles, changing the number of visible suggestions, and setting the truncation method for long addresses and page titlesClick to expand...

Autocomplete Manager 2.3
 

3 more replies
Relevance 50.02%

PREVIOUS REQUEST - http://www.computing.net/answers/office/excel-to-word/10126.html.Assistance given by Derbyday03 and HumarBack again with the gatepass situation. Sorry didn't get back last time, this was due to major changes in the organisation/job shuffles and the vehicle entry proceedures (which coincidentally, have now change back to what it was LOL)A few changes now in our request. Word document changed to an excel document.Overview: As a vehicle arrives it is booked in on an excel sheetDate in A5 and every vehicle book in on at line i.e A7 to F7. This will be time, veh reg, etc..and the info saved.This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.The information needs to be placed in cells of the gate pass sheet as follows:A5 to C2, A7 to E2, B7 to C3, C7 to E6, D7 to C4, E7 to E5, F7 to C6.Once on the sheet a shortcut to print the sheet off and then clear irself ready for the next vehicle information.Is this possibe....

Answer:Auto live transfer from excel to excel

re: This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.I assume you mean "sent to a gate pass sheet in the same workbook" since you can't have a "sheet in the same worksheet"From your description, it seems pretty straightforward...If the data entry sheet is named, for example, "Vehicle Info", and the gate pass sheet is named, for example, "Gate Pass", just use:=Vehicle Info!A5 in Gate Pass!C2=Vehicle Info!A7 in Gate Pass!E2etc.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 45.51%
Question: Excel Auto Sum

In excel when I have a row of numbers and I click in the empty cell below the numbers and click the auto sum button it starts a formula for me. It wants me to fill in the first cell address: and the last cell address. How to I get it to total without me entering the formula. I know it has worked before. I am trying to help someone who is very New to excel and I want to stay away from formulas for now. I just want he to be able to total a column easily. Thank you
 

Answer:Excel Auto Sum

8 more replies
Relevance 45.51%
Question: Excel auto sum

Why I am just going the value in the cell and not the sum of the numbers ? I have excel 2013
how do I fix this?
 

More replies
Relevance 45.1%

I have a sheet that have auto updated prices from the net. can I set a task to action at certain times of the day so it copies the data from one form lets say at 10:00pm daily it grabs the data from form1 cell a1 and pastes it to form2 cell a1 then the next day it grabs the data from form1 cell a1 and pastes it to form1 cell a2.

More replies
Relevance 45.1%
Question: Excel auto date.

Hi!

Is there any way to get Excel, to automatically insert the date into the first cell in column A everytime a new row is inserted?
 

Answer:Excel auto date.

13 more replies
Relevance 45.1%

Have an excel written sheert. Two columns are for names. There is some sort of auto complete being used and some names fill when typing them in. I can not find the file. I would like to edit it and add some and remove some names. I looked in options and it is not listed there. Help please!! TY
 

Answer:Excel Auto complete help!!

6 more replies
Relevance 45.1%

Hello.

Seeking help with a worksheet/Sorting question.

I have a three worksheet workbook. The first is a master list of First/Last names, phone extensions and office location and is sorted alphabetically by last name.

The second worksheet pulls name and extension (using formula:=Sheet1!A1) and is sorted by extension.

The third pulls name and office location (using formula: =Sheet1!A1) and is sorted by office number.

If I add a name to Worksheet1 at the end of the list, it transfers into Sheet2 & 3, but is not sorted in the sort defined sort order. I'm trying to figure out how I can enter data into the master on Sheet1 and when I move to sheet2 or 3 have that data aoutmatically refreshed or resorted so that it is in the appropriate sort order.

I am guessing that macros may be the answer, but thought it was worth an expert opinion first.

Thanks in advance.
 

Answer:Excel: Auto Re-sort

Can you please post your workbook or sample workbook showing the structure of the data? It should be a very simple code to add to your Worksheet_Change event.

Rollin
 

3 more replies
Relevance 45.1%

is it possible to auto fill an excel cell with simply the name of the sheet (tab) it resides within?

Answer:excel auto fill Tab Name

Try this:=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)You have to save the workbook and then recalculate for the Tab name to replace the #VALUE error.

2 more replies
Relevance 45.1%

hello, I am currently looking for a way to make my excel spreadsheet (That we are displaying in our office on a tv) to auto scroll to the information, stop every five lines and return to the top when it hits the bottom
 

More replies
Relevance 45.1%

I want to be able to enter a number in a cell and have it automatically become a hyperlink to a row on another worksheet in the same workbook. Say I enter "23" then whenever I click that cell it will take me to row 23 of the other worksheet. Thanks in advance.
 

Answer:Excel auto hyperlink to row

I think what you're asking is doable in VBA. But with a little compromise- can be esily achieved with a simple formula. The compromise being that the hyperlink will be an adjacent/another cell and not the actual cell in which you enter the row number for your jump-to location.

Say you enter the the row number you require in cell sheet1!D3, then you could have the hyperlink in sheet1!E3 containing the formula

=HYPERLINK("#Sheet2!" & D3 & ":"& D3,"Row number " & D3)

which would take you to the desired row number in worksheet 2.

Hope this helps. Get get back if you want to rack some brains on the vba solution.
 

1 more replies
Relevance 45.1%
Question: Excel auto format

Hi!

I have recently switched to a new computer using windows 7

In the past, in order to auto format a large amount of cells with a formula and values, all I would have to do was enter the formula in a couple of cells and then click on them and drag.

Now, clicking and dragging put the formulas into the new cells, but the value does not show until I click on each individual cells formula bar and press enter.

Could someone please tell me how to set the auto format so that the value is copied and shown automatically (and not just the formula)

Thanks
 

More replies
Relevance 45.1%
Question: Excel auto dating

When I type 6-23 in a cell it is converted to read:
23 Jun. How do I turn this feature off. I want the cell to
read 6-23.
 

Answer:Excel auto dating

6 more replies
Relevance 45.1%

Hi,
my problem is the wrong answer for auto sum. for example,
A B
1 2
1 3
result 2 2 -->using Auto sum function
cell B3 the result should be 5 but result is = 2
However, the result will be correct after i save the file.
what wrong with this formula? Is the file has a virus? I scaned Virus but can't detact it.
please help me
thx,
 

Answer:Excel: wrong auto sum

15 more replies
Relevance 45.1%

I want to make a spreadsheet that helps students calculate the lowest possible value they need to get in 2 remaining quarters in order to pass for the year, but I don't know how to set up a formula for it. Example: Student has Q1: 65%, Q2: 60%, Midterm: 24%, Q3 (so far): 54%, Q4: X, Final:X, and must all average out to 60%. What would my formula look like for a lowest possible value in order to get overall avg to 60? Thank you very much in advance!

Answer:Excel auto-averaging for a set value

Two values will give an simultaneous equation depending upon the weighting.

4 more replies
Relevance 45.1%

Hi,

Everytime I type in "HSI" in the cell of excel, it automatically change it to "HIS". Same w/ "TEH" to "THE".

How do I prevent this auto spelling checking feature?
 

Answer:Need help in Excel...need to prevent this auto...

7 more replies
Relevance 45.1%

Why everytime i tried to close my excel [all excel file], will have one error screen prompt out. Stated "The information you were working on might be lost. Microsoft Office Excel can try to recoever it for you" Then one check box with "Recover my work and restart M. Office Excel" with 2 button below, "Send Error Report" and "Don't Send"

Answer:Excel Auto Recovery

Hi,A number of questions:1. Does this happen if you open Excel and Close it without opening a Workbook (only a new blank workbook open)2.Was Excel working OK before.3 Have you installed any new programs recently. Sometimes programs create add-ins for Excel which cause problems4. Have you checked any add-ins - goto Add-ins in Excel Options and clear all checked (ticked) items.5. Have you written and saved any macros.Regards

5 more replies
Relevance 45.1%

Is there a way to turn off the automatic backing up of files in Excel 2007? I figured it out in Word, but you don't get the same option in Excel.
 

More replies
Relevance 45.1%

I have trouble accessing the file that is saved as an auto save. the pathname of the file on my PC (Win XP) is as follows:

c:\Documents and Settings\Owner\Application Data\Microsoft\Excel

I tried doing a search for this path...no luck.

How can I find these auto saved copies of my Excel document?

Thanks
 

Answer:Auto Save in Excel 02

you should uncheck "show hidden files and folders" on the advanced tab in the folder options - that should allow you to browse to the folder and see those files
 

3 more replies
Relevance 45.1%

I have an excel file that contains several fields, of those fields
I have 2 fields that match and a dr and cr that offsets. I am trying
to create a macro or anything that will work that will take those
matches and store them on separate spreadsheet and leave the records
that have no matching data.

Any help would be appreciated

Thanks
Cipriano
 

Answer:Excel auto matching

All the match will do is return the location of the match from the array or range of cells. You might be able to do this conditionally.
 

1 more replies