Sending the automatic mail

Hi,

Recently I am using this code to automatically send the mail to the recipients when the certain criteria is met, in my case if the date difference between the current date and date stated will equal 3 days.

Please Login or Register  to view this content.

First it was a manual code. so that I had to run it from macros menu manually, but recently I decided to make it automated, so for every Workbook open event the code will run.

So in the first case I located the code in Modules division, but for Automated version in my opinion I have to locate the Code in Workbook division, as Workbook_open is a workbook event.

but I am getting this error: member already exists in an object module from which this object module derives

Could you please help me to solve this issue??

Did you delete the SendEmail() code from your module?

Can you attach your workbook with code in place as an example?

I think Sendmail might be a reserved word. The attached seems to work. Sendmail(1).xlsm

On a side note you really should declare and give a data type to all your variables.

My mistake. I commented that out so I wasn't automatically sending you emails while I was testing.

If you are happy with the solution please mark the thead as [SOLVED] using the thread tools at the top.