Hi, i am reasonably competent in using excel but i am clueless when it comes to VBA, i dont even know where to start.
I have a spreadsheet which gives me a date when a item of equipment needs re testing, i believe that i can set up a email notification if the date falls in a certain range.
Can someone please advise me how to do this is simple terms?
Thanks
There's at least a couple of ways this could be done assuming that you are using Outlook.
One is from within Excel and would get Excel to create and send e-mails. If your particular workbook is not opened, then no e-mails would get sent.
An alternative is to acheive the same outcome but from within Outlook. Working on the basis that you are going to have your E-mail client open every working day, this would mean that messages would be sent out more promptly.
Either way, you would probably need to have a column in the workbook which showed that a message had been sent to make subsequent runs of the code not send it again.
Any preferences?
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks