 | Junior Member with 2 posts. THREAD STARTER | | | |
 Automatic e-mail sending from Excel Hello all,
I am new to Tech Support Guy and to macros/VB code. I hope my question make sense! I have looked at other threads
but I don't even have the understanding of which bits of code are adaptable to my needs.
My colleagues and I run Office 2003 (with Excel and Outlook) and share a spreadsheet of client data to allow us
to co-ordinate our business with them.
At present our work is overly dependant on individuals remembering to action a task, and on paper lists in
different places. I want to try to bring us up to at least the 20th Century!
Our principal concern is when paperwork is due to expire and needs sending off by post to another team
to re-validate the paperwork (column M). I would like the spreadsheet to keep track of when paperwork is expired and to send
an e-mail alert to myself and my colleagues to make sure that we can get it sorted.
The e-mail would say something like:
subject: 'Charts for signing'
Main text: The charts that require new signitures are:
...and then a the rows of the spreadsheet listing the clients that have expired paperwork.
I enclose the spreadsheet with a couple of fake examples to try to explain what I mean. In this example I would want the
information in the bottom row (or at least the first three columns from this row) to be detailed in the email. I would not
have the ability to install software that could help with the process.
Each time we had re-validated paperwork sent back to us the spreadsheet could be updated (by hand by the recipient). The ideal
situation would have the spreadsheet checked once a week automatically to identify the expired charts.
Could anyone out there suggest in the simplist of simple terms how I might start to solve this?
Thanks in advance,
CJ |
Search 
