Dear Gurus,

I need your help i have a UDF function to send mail from Excel VBA whenever a cell value is not blank, the function works exactly as i want , but the issue is when i close and open excel again, all the old mails are resent again, i would like to know how i can stop this. I have used the solution from http://www.jpsoftwaretech.com/excel-...il-from-excel/ for the UDF to send mail.

Would require your help at the earliest.

regards,
Modh