Here everything is working fine.
I am not getting why it won't work from your side.
So do this,
Go to Mail settings and select Authentication Method as "AUTH LOGIN" and provide your mailid and password.
Let me know what you are getting this time.
Still not working , is theone I sent you sending emails and if so to whom and where did you amend the address on the dashboard.
Its cool honest if you want to leave this , this sort od stuff is enough to drive anyone barney !!!
I worked on your file only by changing with my emailID in the script for corresponding 30 days and reload the file.
Now i got my email in the listbox.
I gave my credentials in the Mail settings window.
I provided the button actions in OnOpen trigger also.
Now if i click on button or close and open the file also the trigger fires and i am getting a new mail alert to my inbox.
This is what happening from my side.
Last response I promise!!
I have gone into the Alert and removed the formula for the mail receipients and put my address in there and it still did not work !!!
I really think my issue is with the alert function - But I simply dont understand
Thanks a mill for all yuour help I will post again if I get it going
Just do a test like this.
1.Go to Alert window,In the recipents list give your emailID and check AlertID(AL01).
2.In the mail settings provide settings like how i specified in the previous posts.(Auth Method:AUTH LOGIN)
3.Take another button and provide macro action only.
Now click on the new button and check your inbox after that.
Reply me with your result.