Computer Support Forum

Set email reminder base on Excel

Question: Set email reminder base on Excel

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

Relevance 100%
Preferred Solution: Set email reminder base on Excel

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

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

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

Answer: Set email reminder base on Excel

16 more replies
Relevance 105.78%

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

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

Answer:Excel Email Reminder

Hi, welcome to the board.

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

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

2 more replies
Relevance 75.03%

hi there,

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

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

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

Answer:Set email reminder based on excel

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

Code:

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

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


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

1 more replies
Relevance 75.03%

Hello Everyone!

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

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

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

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

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel

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

1 more replies
Relevance 75.03%

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

More replies
Relevance 75.03%

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


Thanks sooooooooooo much for any help or advice.
Regards
Vinny
 

Answer:Automatic Email reminder in excel

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

1 more replies
Relevance 75.03%

Hello there,

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

Thanks for your time.

Tim
 

More replies
Relevance 75.03%

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

Answer:Auto Email reminder from Excel

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

1 more replies
Relevance 75.03%

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

Hi everyone,

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

The email should look like:

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

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

<personal email signature>

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

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

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

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

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

16 more replies
Relevance 74.21%

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

The dates would be as follows:

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

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

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

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

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

More replies
Relevance 74.21%

Hi Guys,

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

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

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

Answer:Auto Email reminder from Excel Sheet

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

1 more replies
Relevance 74.21%

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

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

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

thanks
 

Answer:Set email reminder based on conditions on Excel

10 more replies
Relevance 74.21%

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

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

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

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

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

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

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

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

2 more replies
Relevance 73.39%

Hello Everyone!

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

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

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

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

I'd really appreciate any help,
 

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

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

1 more replies
Relevance 73.39%

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

More replies
Relevance 72.57%

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

Answer:Excel worksheet to send auto email reminder to clients

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

2 more replies
Relevance 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.6%

Hi, i am new to this forum. Can anyone tell me if i can have a date reminder system for my database in Access? Basically its a licence database and each year a form has to be isgned by each licence holder. is there a way the program can remind me for each name when the form needs to be resigned each year on a particular date?many thanks

Answer:Microsoft Access Data base date reminder?

There doesn't seem to be that facility in Access.Just as easy to use Outlook I would think.

3 more replies
Relevance 55.76%
Question: Email Reminder

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

Thanks,
Ted
 

Answer:Email Reminder

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

Sorry.
 

2 more replies
Relevance 55.76%

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

More replies
Relevance 55.76%

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

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%

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%

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%

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

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

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

Answer:Auto-email Reminder

16 more replies
Relevance 55.35%

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

Answer:Set email reminder in Calendar app

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

1 more replies
Relevance 55.35%

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

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

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

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

More replies
Relevance 54.53%

Hi

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%

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%

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

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

Please use password lfc1979 on the login screen
 

Answer:Solved: Excel outlook calendar reminder

9 more replies
Relevance 54.53%

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%

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

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

please help.
i have attaced the file.

thank you so much.
 

More replies
Relevance 54.12%

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

Answer:Excel 2013 auto sending of reminder e-mail

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

3 more replies
Relevance 54.12%

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

More replies
Relevance 54.12%

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 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 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.48%
Question: email data base

Can anyone tell me how to create / setup an email data base that can be used for my website and front page?
 

Answer:email data base

It depends on how you want the database set up. Do you want visitors to fill out a form and have the results go directly to the db? Like for a mailing list or something? Do you have a host for your site? Most hosting companies have a mailing list/database manager. You would then just need to set up the form and have the results go to a file on the server.

TT
 

3 more replies
Relevance 51.66%

I need a simple data base to keep track of inventory items, mainly just simple data like cost, taxes, shipping, sales price and profit.

I have a Access DB started up and everything seems fine and I can get a over all sum of items from the top down but if I want it to autofill, like I have on colum that is purchase price, the next one is tax, the third one is total, how can I make it auto add or subtract within the same row?

Maybe it would be easier to use excel for what I need but I would rather use Access since it seems like it is a lot more powerful for DB's

Any other ideas or suggestions on inventory software? One day I will plop down for an expensive ap if I need it but until then I need to get by.

Answer:Access, Excel, Inventory data base help.

http://office.microsoft.com/en-us/ac...879071033.aspx

That should give you some ideas.

2 more replies
Relevance 51.66%

Does anyone know of a converter to change a WDB file to an Excel file? Or, does anyone know how I can get the WDB file to open in Excel?
 

More replies
Relevance 51.25%

Hello,
I have four computers at home, one on a VPN that my wife uses for her work and it's strictly hands off for me. Then I have a desktop as my main home computer, and two laptops. All are connected to the cable modem, two by Ethernet cords, two wirelessly.

My workplace has a Web-based email service. Most of the time, I can access it just fine. But now and then, and never with any consistency, I can't access the email portion of that site. I can access everything else on the site, just not the email. This is the same for all three of my home computers. When I hop onto my Sprint card via my laptop, I can access my work emails just fine. When I resync my modem, then all is well and I can access my email just fine.

I have tested my network by running a wire from my Comcast business modem to my one desktop computer, bypassing the wireless router. Still, I can't access the email portion of the Web site.

Any suggestions. Please keep it simple, I'm not as smart about the ever-emerging technology as I once was.
 

More replies
Relevance 50.02%

An Excel Macro to find only the exact wordn & copy rows based on a keyword listI am using the below scriptSub carHunter()'Determine last row with data in Sheet 3 Column A lastSrc_rw = Sheets(3).Range("A" & Rows.Count).End(xlUp).Row'Loop through list of cars For Each car In Sheets(3).Range("A1:A" & lastSrc_rw)'Search for each car, copy row if found With Sheets(1).Columns(1) Set c = .Find(car, LookIn:=xlValues, lookat:=xlPart) If Not c Is Nothing Then firstAddress = c.Address Do'Find next open row in Sheet 2 nxtDst_rw = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row + 1'Copy row containing found car c.EntireRow.Copy Destination:=Sheets(2).Range("A" & nxtDst_rw)'Search for same car again, stop when no more found Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> firstAddress End If End With NextEnd SubBut if this script is searching for es then it wll copy all words whch has ed on it.Please help. want to copy only that row which has the exact value.

Answer:An Excel Macro to find only the exact wordn & copy rows base

First a posting tip...Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum.As for your question, the Lookat argument for the .Find method is set to xlPart which means that it will return any value where the search string is found, even if it is only part of the cell.e.g. Searching for the text string "hat" will find "hat", "that", "top hat", "hate", etc.If you only want to return values that are an exact match, change that argument to xlWhole. In that case the entire cell must match the search argument exactly.Since I can't see your data from where I'm sitting, I am going to guess that the cells that contain "ed" also contain "es" somewhere in the cell.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.61%

I dumped Firefox as a browser because of 'plugin-container' gobbling up all my mojo.

I loaded Google Chrome and it's very spiffy, but a different program (my database manager) when you click the button next to the email address it will no longer open a virgin email in Windows Mail like it used to. I don't know what code to drop into the "path" box on my program to get it back. Jack - [email protected]

More replies
Relevance 47.56%

I am having some connection problems to a mysql database for a small shop, which is located on a shared hosting server. I am using Open Office Base as a front end on Windows 7. I will create a form which is simple and easy to use for someone that is non technical, I could not use for example phpmyadmin or something that exposes too many options to the employee. OO Base does connect successfully but after a short time of inactivity there is an error message which is SQL Status: HY000 Error code: 2006 MySQL server has gone away. The reason for this has been determined that there is a time out of only 30 seconds which unfortunately I cannot change, as it is set by the hosting company in the my.conf file on the server. They also as most web hosts are of limited help. OK fine so I should just be able to reconnect. The problem is that Open Office proceeds to crash and I have to go through a file recovery window and there are several steps including having to re-type the password again to connect. I really need to solve two things here, prevent OO crashing and also having it realize it lost the connection and just re-connecting, without having to type in the password again. I have tried turning off the auto recovery of files but it didn't work, I have tried adding no restore as an option in the shortcut, also didn't work. I have tried enabling connection pooling, it also didn't work. For reconnecting I tried adding ?autoReconnect=true to the end of the database name a... Read more

More replies
Relevance 46.33%

I have a download speed of up to 20Mb and assume that a 10/100/1000 modem will not be any faster than the 10/100 one. The reason for this is that the 10/100 modem is 5 times faster than the download (theoretical) speed of 20Mb. Am I correct in this assumption? Any input gratefully received. My decision to switch from Virgin to Sky maybe influenced by your input. Thank you.

Answer:10/100t base versus 10/100/1000t base

It is the Router's Network Switch (i.e. its four LAN ports) which is either 100Mbps or 1000Mbps (1Gbps). With a 20Mbps internet connection, the higher port speed won't make any difference to your internet performance.
Where it will make a difference is if you transfer large amounts of data, or large files, between computers in your local network. However, all computers/devices connected by ethernet cable in the network also need to have network adapters that support Gigabit.

2 more replies
Relevance 44.69%

HiIn word you can drag an email into it and it will appear as a link to the said mail. Is this possible in Excel also?thanks

Answer:Excel - drag an email into excel

I can't get it to work in Excel.

3 more replies
Relevance 44.69%

I'd like to suggest having the Off Base and Way off Base news items in the XML News feeds section...possibly as a separate feed or include with the downloads feed. Is this viable?
 

Answer:Off Base and Way Off Base in XML News feeds

I will have to ask Jim, I am unsure.
 

1 more replies
Relevance 44.28%
Answer:convert email id to another email id in Excel

Please do post your question more than once.I have deleted your previous post of the same question.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 41%
Question: Email from Excel

I have been reading and reading and have seen you guys help out. But most of the VB have been more then what i need, at least i believe so, not sure.

Also been trying to learn code. It's harder then I ever thought.

I have been trying to find a way to have excel auotmaticly sent me an email when a bill is coming due. I already have a column "G" that change to true or false. I would like the email to be created when "G" reads "true" and sent me email saying is due. Also if and how to have it open and update on is own??? Saw something about ClickYes???

Thanks for your help, John
 

Answer:Email from Excel

10 more replies
Relevance 41%
Question: Excel to email

I have a list of 27 email addresses in Excel and need to use these to send out a newsletter. I normally get this amount each month and am sending out newsletters by manually copying the address from Excel, pasting into Outlook, adding the attachment (newsletter pdf) and pressing send. It takes up a half of my working day!The newsletter is the same in each case. The subscribers to the newsletter is slowly growing, so I would prefer not to spend a whole day cutting and pasting addresses1Is there an easier way to do this?Many thanks in advance.

Answer:Excel to email

You may be able to e-mail 'directly' from Excel. There is a lot of example code by Ron de Bruin click here and an add-in click here but these are all to do with sending Excel files (or parts thereof).Take a look. If you see something potentially useful we can probably modify it to send a PDF.

10 more replies
Relevance 41%
Question: Excel And Email

I am using Windows XP system with 250 mg RAM. My email program is through MSN.

I received an Excel spreadsheet as an email attachment. When I attempt to open it, the document opens in "Word Pad" and is scrambled. I am not given the option to search for the appropriate compatible program either.

I have Office 2000 installed and I can open spreadsheets created in Excel format through the "My Documents" folder with no problem. I can also create spreadsheets, so I am certain the program is functioning correctly. Additionally, I have no problems opening email attachments that are in Word format.

All suggestions are welcome. Thank you.
 

Answer:Excel And Email

Look at the file extension on the attachment. You may find it has been zipped or something in order to get it through a firewall.
 

2 more replies
Relevance 41%
Question: Email from Excel

I have the code working but i want to make sure I don't screw it up. It is set to send an email 14 days before the due date. But i want it to send another email 7 days before and then at 1 day before.

Also i would like it to send the emails without having to open the excel file.

Thank you in advance. I am new at this coding and trying to learn to improve my companies communication.

I have attached my workbook.
 

More replies
Relevance 41%
Question: Excel- Email

My OS is windows vista home edition and gmail. With my Excel 2007 gridlines checked, the gridlines does'nt appear in the email.
Please help.
Thanks.

More replies
Relevance 41%
Question: Excel email

Hi, in excel when I send a document with gridlines to email with outlook via the email icon on toolbar , the recipient gets the document without the gridlines.
 

Answer:Excel email

Hi Painter guy, welcome to the board!

If you go through your mail client (i.e. Outlook) and attach the file, then send, do you have the same problem? Which version are you using? Have the user go into Tools | Options | View and make sure gridlines is checked.
 

3 more replies
Relevance 41%
Question: Excel by Email

My brother has created a spreadsheet using Excel that he wishes to send to me. I do not have Excel software nor have I ever used Excel. I have Windows 98, 433MHz, 96MB Ram, Outlook Express 5.0. Can this spreadsheet be sent to me in usable form by Email? Thanks for your help.
 

Answer:Excel by Email

Suppose that depends on what you mean by 'usable form'. You can download <a href="http://www.zdnet.com/downloads/stories/info/0,10615,28292,00.html">Microsoft's free Excel viewer</a> which will allow you to open the file but not to edit it.
 

1 more replies
Relevance 40.59%

Hi I have a developed a spread sheet that shows the expiry date of our contractors insurance documents and need an email alert to be set up to request the new documentation. Table Example:Column A= Company name/Column B=type of insurance/Column C=expiry date.The Spreadsheet shall only be opened once a week so I would need that to act as a trigger and for the email to be sent 2 weeks before the actual expiry date. Many thanks for the help!message edited by gillkate

Answer:email alerts on Excel

Look here, should be everything you need:http://www.rondebruin.nl/win/sectio... MIKEhttp://www.skeptic.com/

6 more replies
Relevance 40.59%

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

Any way of controlling the time a email is sent via a excel spread sheet using vba?
 

Answer:Excel - macro email-

6 more replies
Relevance 40.59%

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

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

Answer:Automatic Email from Excel

7 more replies
Relevance 40.59%

Hi Guys,

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

I have attached the file below.

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

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

Kind Regards,

Gareth
 

Answer:Automatic Email in Excel

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

2 more replies
Relevance 40.59%

So I need help on something very easy.
I need to have excel email just one person when a due date is met.
This is really simple
the cell in A1 will be the current date, aka =today(), and the cell in C1 will be the impending due date, like =A1+45, and B2 would be the function, in which =IF(C1=A1, "alert", "not due")

I need the email to be sent if B2 reads alert.

OS Windows 7
Office 2010
 

More replies
Relevance 40.59%

I have read a couple of posts here on this very subject, but admittedly, this is over my head and I need some help. I am currently using Windows XP, Excel 2007 and Outlook as my email client however, others in my office may be using something other than Outlook.

Attached is a page in my worksheet that better reflects what I trying to accomplish. Basically, I need to keep my clients informed of my activity on their project so I want to send them, my boss and others, a form letter containing my notes. A sample form letter is on the second page of the attached file.

My notes are entered into a row of merged cells and at the end of those cells I have placed a button for me to click to send the emails automatically. Additionally, I would like the word "Done" to appear beside this button once I have sent the emails.

Any help would be greatly appreciated.

Thanks

James
 

Answer:Email Data from Excel

7 more replies
Relevance 40.59%

Hi all,

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

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

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

Thank you for your time!
 

Answer:Automated Email From Excel

8 more replies
Relevance 40.59%

Hi,

I want to create a kind of a program where if I enter data into an Excel spreadsheet, that data will be printed onto either a Microsoft Word document or as an email. For example, if I had a Word document or an email written as:

Dear ______,

Thanks.

I want to be able to type a list of names and email addresses in an Excel document, and have it automatically send to those email addresses with the names filled in the blank. Please advise. Thanks.
 

More replies
Relevance 40.59%

This is my first post so be kind if it doesn't have everything you need.

I would like Excel to automatically send an email to a unique email address when a trailer is logged as complete. I've included a spreadsheet as an example. What I would like to happen is when a date is entered in column E, excel would look up a carrier email address based on what is in column B that would be kept on a seperate tab and then email the following..."Trailer # (data from column C) is empty."

I use Excel 2002 and Outlook 2002
 

Answer:Using Excel to trigger an email

You can add as many rows as you want to either sheet, but don't change the layout of the colums or it will break.

I warn you now, it works, so don't click the button unless you are prepared to send an email to the listed contacts on the second sheet. I'd change them all to your email address for now until you are ready to go live with it

I opted for putting a button in because the only other way to do it would be to link the macro to a change cell event which would make it run EVERY time any cell is changed. A button is much easier. Type in all the dates then hit the button and it disperses all the emails to the listed emails for the carriers. I added a column also for the macro to mark a "Yes" in once it has emailed it. That way the next time you press it, those ones are ignored

And i accidentally sent a test email to one of your contacts on the sheet. You should use fake emails when posting examples. I apologized to the guy but he didn't seem to mind.

I didn't comment any of the code as i was in a hurry, if you need more done just write back and i will make the alterations and fully comment the code for you so it can be understood better
 

1 more replies
Relevance 40.59%

HI,

I am running office 2003, I did updates to suite and can not send emails from Excel. I get a not implemented error and that Microsoft Outlook could not be started. Word works fine.

Any ideas, running Norton Antivirus and everything was working till I did the office updates.

Thanks,

Sandra
 

Answer:email issue from Excel

11 more replies
Relevance 40.59%

Dear TechGuy,

Can you please assist me with the macro which I need..
We are using Shared Mailbox in my organization. When a new mail received, we need to copy Date,Time,From address and Subject from the e-mail and paste into the excel for data. It is very hard to do for each and every mail when receives. So i need a excel macro which automatically pulls the data of DATE, TIME,FROM ADDRESS and SUBJECT from the e-mail when newly received.

Hope you clear on above, For more clarification, Please check the attachment, Have marked in RED which i really need.

Many Thanks In Advance,
Usertech..
 

Answer:Email Details Into Excel...

Hi,

Please anyone reply me on above request. Need a solution soon... Thanks..
 

2 more replies
Relevance 40.59%

Hello,

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

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

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

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

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

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

Thank you so much in advance for your help
Colin
 

Answer:Automatic Email from Excel

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

2 more replies
Relevance 40.59%

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

Answer:email list from Excel

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

1 more replies
Relevance 40.59%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.
 

Answer:Email Macro in Excel??

16 more replies
Relevance 40.59%

Is this possible. We have an Excel Spreadsheet with Data.
We want to put a mark in the date field and when the expiry date is maybe 7days away.
For it to either highlight its due
or if possible link to outlook and send an email notification?

http://www.yourfilelink.com/get.php?fid=595994

Or got a good suggestion
 

Answer:Excel email notifications

hi woodland81,

For highlighting the expiry date you can use Conditional Formatting, select the column, Format/Conditional Formatting
then set the condition to be Cell Value Is / Greater than / =Today()+7
, set the format pattern to be say RED.

You can automate emailing with a macro , or alternatively use your data as input to a WORD email merge.

lol
Hew
 

3 more replies
Relevance 40.59%

If someone with access to a excel 10 spreadsheet makes a change in it is it possible to have an email sent to my outlook email address?

Answer:I'm trying to send an email from Excel.

Yes, you can achieve this by using the 'BeforeSave' function. Open the VBA window, expand 'Microsoft Excel Objects' if it's not already, then double-click on 'ThisWorkbook.'Copy and paste the following code into the window: (Note: you will need to change the email addresses and the servername at the minimum!)Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim MailObject As Object
Dim Cconfig As Object
Dim SMTP_Config As Variant
Dim Email_Subject, Email_Send_From, Email_Send_To, Email_Body As String
Email_Subject = "User Has Saved Changes to Your WorkBook"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Body = "Someone has made changes to your workbook and saved them."
Set MailObject = CreateObject("CDO.Message")
On Error GoTo debugs
Set Cconfig = CreateObject("CDO.Configuration")
Cconfig.Load -1
Set SMTP_Config = Cconfig.Fields
With SMTP_Config
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "PUTYOURSERVERNAMEHERE!"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With
With MailObject
Set .Configuration = Cconfig
End With
MailObject.Subject = Email_Subject
MailObject.From = Email_Send_From
MailObject.To = Email_Send_To
MailObject.TextBody = Email_Body
MailObject.send
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
Law of Logic... Read more

6 more replies
Relevance 40.59%

I have a series of cells that are accumulating percentages of defects from samples of our product. Each defect type has its own threshold. What I want to do is setup an email alert through Excel for each time one of these thresholds are exceeded. Can anyone help with this?Thanks..Don

Answer:Email Alerts Using Excel

Hi,If column E contains the % rate then in column F put a formula that changes to "X" when the threshold is reached or exceeded.Add this macro as follows:Right-click the worksheet name tab and select 'View code'In the VB window that opens enter this code:Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ErrHnd

'stop further changes triggering this code
Application.EnableEvents = False

'only run this code if column E (E=5) has changed and next column (F) contains "X"
If Target.Column = 5 And Target.Offset(0, 1).Text = "X" Then
'create the e-mail object
Set objEmail = CreateObject("CDO.Message")
'set e-mail SMTP configuration
With objEmail
With .Configuration.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") _
= "SMTP.YYYYY.com"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") _
= "30"
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") _
= "2"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") _
= "25"
.Item("http://schemas.microsoft.com/cdo/configuration/sendemailaddress") _
= "[email protected]"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") _
= "1"
.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") _
= "[email protected] Read more

25 more replies
Relevance 40.59%
Question: excel email list

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

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

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

Thanks
Danny
 

Answer:excel email list

9 more replies
Relevance 40.59%

I have an excel spreadsheet with some questions on it. I can create a form with the questions on it using "Data - Form". What I would like to do is email this form to about 12 people (instead of the whole Excel spreadsheet) and ask them to complete and return to me. Is there any way that this can be done?Thanks in advance.

Answer:how to email an excel form

I don't use Excel but normally, in the case of MS programs and applications, from (generally) File you can usually Send To i.e. in this case a mail recipient or recipients.

6 more replies
Relevance 40.59%

Hi All,

I need help.
I have a preventative maintenance spreadsheet for 30 pumps. (rows 2-31)
Each pump has different servicing dates (some weekly, monthly etc).
Each week i would like excel to send a reminder (via outlook email) and auto filter the list based on which equipment needs servicing.
In columns H (row 1) onwards I have put in weekly dates (every friday) and then put a 'Y' in the relevant cell for each pump (if they require servicing that week) and left the cell blank if it doesn not.

Can this be done?
 

Answer:Email from Excel by Date

12 more replies
Relevance 40.59%

Hi all,

I got this Excel worksheet, where I need a server(or service) to send a e-mail out at due dates.
Using Excel 2010, and the worksheet got the dates at A4 and down... I was thinking of a vbs scribt that is run by a schedule every evening and checked the worksheet for dates.

Let say that there is a date at A13 that says 26-09-2012 it should send out a reminder 4 days before, so that it sends this out at 22-09-2012 reminding using e-mail, with something like:
"Reminder that Mr. John have last work day at: 26-09-2012"
This is for new employees entering/leaving the company, so the rest of the worksheet are:
B = Name, C = Initials, D = Department, C = Location and so on.

I have read many posts on this forum regarding this, but none of them fits my needs.
Is this possible? I imagine this running on one of our serveres for smaller tasks like this.

Regards
 

Answer:Email from Excel on date

Hey JohnG welcome to TSG.

Look at the zip file in Post #8 of this TSG thread. In the VB you can hard code a file name rather than doing the drag and drop thing (after you get it working for your criteria).

To run on a server with admin rights you can remove (comment out) msg boxes and change the MyItem.Display to MyItem.Send and it will work seamlessly.
 

1 more replies
Relevance 40.59%

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 40.59%
Question: Excel email button

I have an excel spreadsheet. I want to put a button on it. When a user clicks the button, it automatically gets emailed to a person that is defined in the code. Thanks !!
 

Answer:Excel email button

Mailto link within Excel
Thought that looked familiar
 

1 more replies
Relevance 40.59%

Hi everyone,

I am Frank and I need some help from all you experts out there. I want to setup my Excel to send me an email alert to my email account when a certain criteria is met. For example in a cell number that I have specified it calculates the sum total of a range of cells to return their sum value. The next cell monitors the value of the preceding cell to see if reached a fixed threshold value. How can I setup my email to make Excel trigger an email to me when the threshold value is reached? Appreciate all your help. Thanks.

FYI, I am using Windows Vista 32 bit with Microsoft Office 2007.
 

Answer:Need help with email setup for Excel

16 more replies
Relevance 40.59%

i am using a excel sheet. in that, days left are maintained against each roll no. if the days left reaches (suppose say as 3 ) i need a mail to be sent to 2 mail id's i wish using the roll no for which the day reaches the value 3. is that possible? i am using excel 2007 and microsoft outlook. kindly let me know.
 

More replies