Computer Support Forum

Auto-email Reminder

Question: Auto-email Reminder

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.

Relevance 100%
Preferred Solution: Auto-email Reminder

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

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

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

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

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

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

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

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

More replies
Relevance 57.81%

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Dear Team,

I have gone though the below thread, which helps somewhat on my requirement but not completely. Please need you kind help on VBA code. Sorry if i have missed any other thread which would have met my requirement.

https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

Here is my requirement...
I have a data in excel (attached file) basically its a re-assigment project which needs 3 tasks.

Column A to E are filled manually which need not be automatic.
Column F has a formula for 29 days date for Column B and accordingly Column H for column F.
Column G & H are the status of task action.
every day we are manually opening the WB and checking for daily pending assignments in column H & F for today's date.

Can you please help me with a VBA code which should send a email notification/reminder not to individual email addresses instead it should send an email to me, If the Column F & H has today's date i.e. current date with the table of data in body of email and update the status as Done in excel sheet once the email has triggered.

Hope you will help me on this. Many Thanks in advance

Example of email
 

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 45.1%
Question: Auto Email VBA

I am looking for the best way to have emails sent out automatically based on an expiration date within a simple spreadsheet.
I need to track dates in order to renew work visas for a company i work for. I would like to use VBA to send an automated email 30 days out of an expiration date from my outlook.

Any help will be greatly appreciated.
 

Answer:Auto Email VBA

There are many examples of vba/Excel email generators in this forum. You should grab one and post back when you have a problem with the code. It may be as simple as using the format on the spreadsheet linked. Understand the email is only generated when the spreadsheet is opened.
 

1 more replies
Relevance 44.28%
Question: Email Auto reply

Hi Everyone,
 
 
I'm try to see if anyone could recommend a tool that can auto reply to emails that I receive. Same like out-of-Office assistance in exchange.
But the problem with MS Exchange Out-of-Office is that the sender receives the Out-Of-Office statement from me only once. and this is how Microsoft has designed their Out-Of-Office.
 
meaning the sender wont receive the Out-Of-Office reply from me for the second email he sends within the same day.
 
That is where I need a 3rd party tool that can do this, regardless of the number of messages I receive from the same sender.
 
 

More replies
Relevance 44.28%

About two weeks ago the auto logon to my (and my wifes) email suddenly stopped working. Normally when we check email we simply click on the Comcast mail icon, and a screen pops up where our user name and password is entered. Normally all we have to do is enter the first letter of our user name and the then the full name and the password are filled in automatically. This no longer happens. We must type in the user name and then the password. Checking the "Remember me on this computer" box does not work. Even when the box is checked, the next time we logon we still have to enter the user name and password. I have checked our settings and everything appears normal. Since it happened on both computers at the same time, I'm having a hard time thinking that it was something I did and just don't recall. Anyone have any clues as to where and what I should be looking for? There must be something I am overlooking. Thanks
 

More replies
Relevance 44.28%
Question: auto email message

I was just wondering if there are any software programs that would show on my desktop if I have recieved an email. So if I got an email, a pop-up or notification would come up on my desktop and show that I have gotten an email.
 

Answer:auto email message

What email client are you using? Or, if you are using web mail, what browser and what email provider?
 

3 more replies
Relevance 44.28%
Question: auto sending email

My email account (yahoo.co.id) started sending a blank email to my contact list subsequently from a, b c...., and always around 00.50 or 12.50. How can I get rid of this kind of virus? and how is to prevent it won't be happenned again in future? thanks for helping

Answer:auto sending email

Email yahoo. On your mail page go to Help - Contact Us and send them an email requiring a reply regarding the problem with as much detail as possible. It's not necessarily a virus. If so, download 10bit security 360 - free version - and do a full scan of your system. It digs pretty deep for problem files.

2 more replies
Relevance 44.28%

I use MS Office Outlook and I would like to do something where when I receive a email it automatically sends a response back stating that I won't be in the office during specified times and dates.
Is there a way to do this or maybe an add-on?
Thanks for any responses!
 

Answer:Email auto-response

10 more replies
Relevance 44.28%
Question: email auto scroll

When I open a new email it automatically scrolls to the bottom of the page instead of on top. Does anybody know how to correct this?
thanks

More replies
Relevance 44.28%

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 44.28%
Relevance 44.28%
Question: Auto email address

When I try to address email in Yahoo, there is no curser in the To: field. I cannot manually insert address and autofill does not work. I can go the contact list and insert from there. How can I get auto fill back again?

Answer:Auto email address

do an online tech support chat with yahoo.Some HELP in posting on Computing.net plus free progs and instructions Cheers

2 more replies
Relevance 44.28%

Does anyone know a place that has an auto foward feature. I am trying to get things sent to my cell and i have an email adress that will send messages to my phone, but I dont want to give out that address. Thanks guys!

Answer:Auto email fowarding

you can setup auto forwarding in gmail.

pm me a email address you have access to and i can send you an invite for gmail.

1 more replies
Relevance 44.28%

Ok i posted this already in DIY projects, but looking at that forum, its all spam so maybe i will get a better response in this one, so sorry for repeating myself.

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.
 

More replies
Relevance 44.28%
Question: email auto scroll

When I open a new email it automatically scrolls to the bottom of the page instead of on top. Does anybody know how to correct this?
thanks

More replies
Relevance 44.28%

My question is simple really, Im not too familiar with office 97 however a friend of mine is trying to get his access 97 to automatically email random data from his db to an email recepient. What would be the best thing to use in order to accomplish this ? Any advice on this subject would be greatly appreciated.
 

Answer:Using access 97 to auto email

14 more replies
Relevance 44.28%
Question: email auto inserts

I'm using Windows 7 64 bit, Outlook 2003, I.E. 8, and sometimes Firefox
Don't know if this is a Win 7 issue or Outlook issue

Clicking on any email link (on any web site) that auto inserts the "Subject", "CC", etc. text brings up a new email but all inserts are in the "To" line immediately behind the recipient's address. Prior to Windows 7, I was using XP with Outlook 2003, I.E. 8 and Outlook Express. Email worked perfectly, placing the subject text in the subject line, etc. What I'm getting now, for example, is ...

To: (recipient's address)?subject=blabla
Subject: (subject line is empty)

While searching for a solution (with my current setup), I found myself on a web site which gave examples of how to write mailto syntax for various inserts. There was a link after each example that you could click to see the results. Every one I clicked on put everything grouped together on the "To" line. "Subject", "CC", etc....everything is on the same line. This seems to me to rule out Outlook as the problem but I really don't know.

Within Outlook I have it set as my default mail handler.
In Set Default programs, however, the mailto protocol is not present. Could that have something to do with this? I wouldn't think so as the mail links bring up a blank email.....it's just that all the inserts are merged.

Thanks for any help
 

More replies
Relevance 44.28%

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

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 44.28%
Question: Email Auto Connect

Since updating Outlook Express & Mcafee Antivirus my Email connection box keeps popping up every 5 minutes asking me to connect (even when I'm NOT connected to the phone line)and interupting the program I'm working on.How can I Stop this happening.

Answer:Email Auto Connect

Does this happen WITHOUT OE or IE running?AH

9 more replies
Relevance 44.28%
Question: email auto test

Hello, your help please.Having set up a new PC with Vista as the operating system I am having a small problem with email. I have a number of email addresses set up in windows mail and keep getting a "Auto test" reply when sending out mail. This is ramdom as to which address is in use and when it does it. I send my email via One.com and did not have this problem before with my old system. Any ideas most welcome, thank you

Answer:email auto test

forgot to state its running on a AMD main chip and has 2 gig memory if thats any help

1 more replies
Relevance 44.28%

Are there any free email auto responding program available? I can't find any.


I don't mind trial versions, as long as it's not available for a limited amount of time.
 

Answer:Email Auto Responder

Maybe?
http://www.google.com/search?q=free...d=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8

Aren't all 'Trials' available for a limited time?

 

2 more replies
Relevance 43.87%

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

I like to remove the auto-response from outlook 2007 the trouble is I can?t find where it originates. I remove all the rules & alerts. I don?t have "out of office assistant" command on the tool bar. their 3 PC on the network so I uninstall Microsoft office on one machine only hoping I will start fresh but to my amassment after re-installation outlook came back up with all the settings and email accounts I guess this is another question but I thought it might be relevant.
 

Answer:Ghost email auto-response

I'm not pretty sure about 2007, i have 2010 atm, but i guess there's an option to disable auto.response.

In 2010 is placed in the "Mail options" > "Answers and auto response".

You could try searching the option .

Cheers.
 

3 more replies
Relevance 43.87%

Does one need special software to setup emails to tell senders that ' I am out of office' or' I am away on holiday until xxx date'?My email client is Barca ( Poco Mail plus )and there is no reference to the ability to autorespond.

Answer:How to Create Auto Response Email ??

This is how to do it in Outlook Express click here and you may be able to do something similar with your e-mail client.Note: doing this from a home e-mail account is an open invitation to Joe Burglar to visit whilst you are away.

4 more replies
Relevance 43.87%

I am using WIN ME and find that the function ofautomatically completing the email address when composing a new message will not work. Only the addressees name appears, not the address.I have checked via Tools/Options/send button and checked that there is a tick in the Autocomplete box. This function worked ok when I had Win98but will not work with ME. Does ME not support this or what can I do to recover this please.Meshuga.

Answer:Auto completing email address in OE.

When the name appears it is automatically linked to an address so it will send the mail OK.

3 more replies
Relevance 43.87%

Today my yahoo mail was compromised by all my contacts being spammed with links....other than changing my password and running an anti virus, i have no ideas how to solve this....can anyone suggestion anything i can do to stop it that wouldn't cost me to buy a product....

Answer:Email auto-spamming my contacts

Please download Malwarebytes Anti-Malware and save it to your desktop.Download Link 1Download Link 2MBAM may "make changes to your registry" as part of its disinfection routine. If using other security programs that detect registry changes (ie Spybot's Teatimer), they may interfere or alert you. Temporarily disable such programs or permit them to allow the changes.Make sure you are connected to the Internet.Double-click on mbam-setup.exe to install the application.
For instructions with screenshots, please refer to the How to use Malwarebytes' Anti-Malware Guide.When the installation begins, follow the prompts and do not make any changes to default settings.When installation has finished, make sure you leave both of these checked:Update Malwarebytes' Anti-MalwareLaunch Malwarebytes' Anti-MalwareThen click Finish.MBAM will automatically start and you will be asked to update the program before performing a scan.If an update is found, the program will automatically update itself. Press the OK button to close that box and continue.If you encounter any problems while downloading the definition updates, manually download them from here and just double-click on mbam-rules.exe to install.On the Scanner tab:Make sure the "Perform Quick Scan" option is selected.Then click on the Scan button.If asked to select the drives to scan, leave all the drives selected and click on the Start Scan button.The scan will begin and "Scan in progress" will show at the top. It may take some time to comp... Read more

1 more replies
Relevance 43.87%
Relevance 43.87%

Firefox auto updated to 3.0.17 prior to the update I had been able to log in to Comcast.net to check my Email. Now when I enter user name and password it just goes back to the Comast.net page and doesn't recognize that I tried to log in. Other sites that require passwords are doing similar things. I switched over to ie and am able to log in to sites with out an issue.

HAS anyone experienced this problem? Is there a fix? I ran a virus scan and it came up blank. I am running XP.

Thanks
 

Answer:Firefox auto updated and now I can't log in to Email, etc

I have the same version of Firefox and have no trouble with it.

You can ask your question from your browser from Help > Help Contents:
http://support.mozilla.com/en-US/kb/Firefox+Help?style_mode=inproduct

For example, you could try installing a previous version, like the one you had before. Here is the link for this:
http://support.mozilla.com/en-US/kb...ox?bl=n&s=install previous version of firefox

There could also be an issue with the installation process for 3.0.17.

BTW I advise disabling auto update. Tools > Options > Advanced > Update > When updates to Firefox are found: check Ask me what I want to do.
 

1 more replies
Relevance 43.87%

Hey,

My girlfriend's dad has asked me to help him set up an auto-response email for him. I agreed to help him although I honestly have no idea how to do it.

The email he has is "Freeserve" (UK service) and he accesses it from Outlook.

If anyone is familiar with freeserve and is able to set it up from the actual freeserve account please post some details.

If no one knows that, could you possibly explain how to do it from outlook.

Thanks alot
Sludeking

Answer:Setting up auto-response email

In outlook:

Click Tools > Out of Office Assistant

Then he can type in whatever he wants the auto reply to say.

3 more replies
Relevance 43.87%

My primary email is a cox.net account but i recently created a gmail account that I will be using since I will be cancelling my Cox soon. I use thunderbird and want my emails from my cox account forwarded to my gmail account. I thought I set it up correctly because they get forwarded when I log in under the gmail web page...just not in thunderbird. Is there something I need to do in TB to make this happen?

Answer:Email auto-forward help needed

I'm not using Cox but all those settings would be on your Cox webmail site online. In Thunderbird all you would show for accounts would be your Gmail one as that's the one receiving all the mail from Cox I believe, so any mail forwarded online from Cox to Gmail online would arrive in your TB Inbox in due course, hopefully.

If you are having problems setting up Gmail in Thunderbird try their support: Thunderbird Support | Thunderbird

2 more replies
Relevance 43.87%

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

New to hotmail, how do I stop hotmail emails from opening one after the other, could not find option to stop this! Thanks in advance
 

Answer:hotmail opening email auto?

Forgive me, I'm not clear on what you mean. Could you explain?
 

3 more replies
Relevance 43.87%

I am with freedom2surf broadband and use Microsoft Outlook for my email. I am on holiday from Friday and would like to set up an auto-reply but there's nothing in MS-Outlook that enables me to set this up. I have my own email address.Many thanks to anyone who replies

Answer:Email Auto-Reply .. for the layman

i think you would require exchange to do this

5 more replies
Relevance 43.87%

I am running XP PRO with Outlook2003.

Previously, in Outlook Express when sending email you could type the first few letters of someones email address and it would automatically place it on the "To" line. In Outlook 2003 it finds the address in your address book but does NOT auto populate the address. You have to highlight it and click to get it to the "To" line. Is there a setting to make it work like Outlook Express?
 

More replies
Relevance 43.87%

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

I worked thru a virus infection previously here at the forum. it was lengthy and intense but I think we got the system cleaned up. Recently, I noticed that some of my email replies are not be saved. I used Outlook Express and have it set to automatically save all sent messages. My messages to At least one person that I contact every day are not being saved. A vast majority are saved but at least one person that I have noticed - when I reply to their emails, I am not getting a saved copy. Can you help me figure this out?
 

More replies
Relevance 43.87%

Hi. l use Hotmail as my email .its worked ok up to now but the auto fill has stopped working .the tools in the internet browsers look ticked to on .but l don't know how to check auto fill in Hotmail anyone now how to fix it . Thanks.

Answer:auto fill not working in email.

Do you mean the prompt for the email address? If so see Ask Leo

1 more replies
Relevance 43.87%

Hello,
XP has an auto image rezier when you right click an image and send it to a mail recipient. It stopped working a little while ago. No changes to the system were made. No new hardware or software. Does anyone know where this option is located, maybe I need to turn it back on. I could not find this feature at microsofts site. Any help would be great. Thanks.
 

Answer:XP auto image resizer for email

6 more replies
Relevance 43.46%

The Outlook feature that automatically suggests email addresses as I begin to type in an address in email is not including many addresses that are no longer current. For example, when I try to send a message to my wife, it offers a list of six addresses, four of which are obsolete. I cannot find the file that contains these addresses to edit it. The various manuals speak of .wab files, but a search produces none. The only .pst file I can find doesn't contain the address list. Anybody know how to solve this one, I hope? BTW I am using XP and Outlook 2002.
 

Answer:Outlook auto email address completion

7 more replies
Relevance 43.46%

howdy all

I have a problem... how do i prevent an email loop from happening on my exchange 5.5 server?

right now we have an auto reply set up for an inbox and it automatically sends a reply when it recieves an email but yesterday it got one from a hotmail address and it looped with the hotmail account returning our email saying the account is full and us sending a reply back for recieving the email etc.

how can i prevent this from happening again? this auto reply email loop.

thanks
 

More replies
Relevance 43.46%

Does anyone know of any programs or ways to automatically send emails spaced at intervals? My server will allow limited emails sent at once. I have been publishing a newsletter for http://www.investrend.com, called "First Alert" for quite some time now... all recipients are subscribers... but I have to send it out in groups of less than 500 at a time. I'd like to automate thie process. And can a timer program (or method) be integrated with an email utility (like Vallen Emailer or YAMS)?

My computer: Toshiba Satellite 2405-S201; BIOS: Toshiba Version; Version: 1.20; Processor: Intel Pentium 4 Mobile CPU 1.60 GHz; Speed: 1594 MHz; Memory (RAM): Capacity: 256 MB; Total Hard Disk Capacity: 27.95 GB; Windows XP Home Edition (Version 5.1.2600; Build; 2600.xpsp.030422-1633 : Service Pack 1.0); A 32 BIT SYSTEM.

I appreciate (in advance) any assistance... and I WILL respond to let folks know how things work out.

Thanks again.

 

Answer:Auto-timer-based email sending?

Well, normally I avoid these sort of programs and do not know of one by name, but you need basically a spamming sort of email program. You can search Google for bulk email, mass email marketing or similar terms for a program capable of doing that. Of course, you can check other software sites that post that sort of thing
 

4 more replies
Relevance 43.46%

Running Visa Home 32 bit on a laptop, using Windows Mail/Outlook. The email address auto complete was working then all of the sudden it stopped. Now it will auto complete only email addresses that a message was sent to in the last 24 hours. I checked the settings and they are correct, it should be auto completing. I tried going in and deleting the reg key for that, no help. I restored it. I personally don't use Vista, this is for the bosses wife, so I don't know a lot about what else to do. Any help is appreciated. Thanks

More replies
Relevance 43.46%

Hello,I receive a few dozen emails a day which contain an attachment. Upon receiving it I send an "OK" reply if it contains correct attachment type and save that attachment to a folder. I am looking for a way to automate this process. Have looked at thunderbird and some addons like filtaquilla but they don't do what I want. Google isn't of much help either.Is there any kind of software to do this? I'm using Windows XP and Gmail account. Any advice appreciated.

Answer:Auto reply to email based on condition

Not sure how an app or addon would be able to determine if an attachment is of the correct type...or not so my guess would be No.

4 more replies
Relevance 43.46%

When I go to My Pictures (WinXP) and select a pix then click on email this file, it asks if I want to resize it for easy mailing (which I do) then it should automatically open an email for me but nothing happens! No errors nothing! I think it has to do with my Walmart Connect setting or software but can get no help from them. Should there be something in The HTML EDITOR box of my internet options? This is the only thing I see that looks suspicous.
 

More replies
Relevance 43.46%

howdy all

I have a problem... how do i prevent an email loop from happening on my exchange 5.5 server?

right now we have an auto reply set up for an inbox and it automatically sends a reply when it recieves an email but yesterday it got one from a hotmail address and it looped with the hotmail account returning our email saying the account is full and us sending a reply back for recieving the email etc.

how can i prevent this from happening again? this auto reply email loop.

thanks
 

Answer:Exchange 5.5 auto reply email loop

What do you mean a loop? Did it get stuck sending and receiving for the same hotmail account over and over again? There might be a setting for non deleiverable returns (NDR) on the mailbox where it won't receive or accept NDR's. There might even be something where you could set up a rule for NDR's so they get sent to another mailbox and deleted.
 

2 more replies
Relevance 43.46%

Hi

I have a question about blackberry, does it save the address you sent email to last time and auto prompt when you type the next time? If so, how do you do it?! It's getting very frustrating typing the entire address every time.

Thanks
Nick
 

More replies
Relevance 43.46%

Hi all. I think this is an auto complete thing...

I have been logging into my email accounts via webmail for years via the same url. I have four different email accts, and when I load the page, I simply dbl-click in the email field, and I see all four addresses. If I click on one, the pwrd auto-fills, and I am good to go.

My host recently swapped me to another server, and I now have to access my webmail via a different url. I go to that url, and there are no email address there when I dbl-click in the email field. Ok, no biggie. I enter the first address and pwrd, and log in. Windows does not ask me if I want to save the username and pwrd. Weird. I log out, and log into the other three one by one, and with each, I am prompted to save the username and pwrd, which I do. I log out of the fourth one, and then attempt to log back into the first - which I can do, but Windows again does not prompt me to save the username and pwrd. I have rebooted twice, and each time I log in to that specific email, I just log in - no prompt. And that email is not in the email field when I arrive at the log in page.

Anyone have any idea what the heck is going on?

Thanks in advance.

Answer:Can't get auto complete to remember an email address

That's a nice explanation, but, what the heck webmail and browsers are you using??

If you're using IE, see: Internet Explorer AutoComplete - Turn On or Off for settings.
Since your Host changed servers that first addy may have to be placed in a trusted zone.
There's the possibility with the transfer of servers, the new server still thinks that, that first addy is already saved.
It could be the new server doesn't recognize a security certificate for that addy.
If browser settings are okay, I'd check with your Host.

And please; It would be very helpful if you would fill out your System Specs, you can use the tool included in the Tutorial here: System Info - See Your System Specs just read through the tutorial, use one of the downloads, and it will automagically fill them in for you.

Your welcome.

4 more replies
Relevance 43.46%

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

I've always had my email addresses in outlook auto complete themselves (the email address is in the contacts folder), but now it won't any more, since I had to re-establish outlook again after a reinstall. I can't find where to turn this feature on. what I mean is, if the address is, say, [email protected], then all I type is pet...and it completes.

thanks!
 

Answer:how do i turn on auto-complete for email addresses?

bj nick,

In Outlook, go to Tools > Options > Preferences > E-mail Options > Advanced E-mail Options

In the When sending a message section, check the 'Automatic name checking' box.
 

3 more replies
Relevance 43.46%

I switched over from OE to Outlook 2000 and I had a question about auto-fill email addresses.

In OE I could start typing a name, say Joe and OE would automatically fill in as I typed the name if it was in my address book. So instead of typing joe smith, I could type jo and joe smith would be filled in.

Does anyone know if Outlook 2000 will do this same thing? I have looked everywhere for answers and I can't find anything.

Thanks
Mike
 

Answer:Outlook won't auto fill email addresses

I believe you either need Outlook2002/XP for that to work automatically or you can press Ctrl-K and it will pull up names in the Contact list.
 

1 more replies
Relevance 43.46%

I recently accepted an invitation to a teleconference meeting. Ever since then, MS Outlook 2007 the auto preview pane for messages is not working. I used to have the preview in a column to the right of the listing of messages. I found this question has been asked before on this forum, but the thread has expired. Any help will be appreciated. Thanks.
 

More replies
Relevance 43.46%

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

Hello

Does anyone know how to automatically save email addresses of messages in Outlook that are responded to, or put in another folder?

Can it be done with code?
Thanks


 

Answer:Auto Save Email Address in Outlook

6 more replies
Relevance 43.46%

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