Hi, I've searched and found threads related to the issue I'm having, however I've been unable to adapt the code to suit my needs. The current code I'm using is a copy from a website, as I'm still trying to get my head around VBA.

I have created an excel 2010 spreadsheet that includes nine columns with dates (the original sheet has several hundred rows). The purpose of the sheet is to track access cards that have been issued to staff, associates and athletes. To gain access to the department's facilities, various certificates (current) have to be provided, therefore dates will expire at different times. I have set conditional formatting for the dates due to expire in 30 days, and those that have already expired.

Because the register is fairly large in size, I would like a macro that would enable the user to press a button that will search across the nine columns for dates due to expire in 30 days and create a reminder email to send to the cardholder (individual emails). The email should only show the type of certificate (as per header) and the date it will expire, and a date that documents are to be provided by.

I’ve attached a sample file to give a clearer picture of the type of help I need. I hope I’ve made myself clear enough and have complied with the forum rules. **having probs with upload**

Thanks for any help I can get.

Please Login or Register  to view this content.