OK, I have looked at this site and seen some brilliant idea's in regards to using VBA.

I have a stock control system using an IF Statement / VLookup formula, so when you put in a code, it returns the correct item matching that code.
My system is an 'on loan' system, so that the items are returned with in 6 weeks of it being signed out.

The system works perfectly fine as it is, but i want to add features to it.

I want excel to send an email to the person who signed out items 1 week before they are due for return. I want to keep a list of all items signed out on one sheet. So that every 6 rows would be a new record as you can only sign out 6 items at a time.

I currently have a test spreadsheet to experiment with that has VBA Codes which automatically update the date upon opening the work sheet and can send an email when the date matches the date in a specific cell, which links into the auto date update.

Unfortunately, it will only send the email every time i click a cell. (selectionchange event).

Is there a way to change it to send one email, to different people, listing the resources those individuals signed out?

Any help would be very much appreciated! If there is a thread that would answer (or help) then again, would be very much appreciated!

Thank's in advance!