I have totally saved down your file to have a look at , but when I trigger the macro to run , it does not send the mails
( in my user preferences I have it set correctly ( as the test mail sends) and I have changed the employee mail addresses to my own)
Yet when I press Go>> nothing happens ( as in - it does deselect accordingly but not send mail !!)
Can you please help as Id love to be able to use this
Yes you can schedule(through windows scheduling) that file if you put all the actions which are available in button in "OnOpen" sheet trigger.
What the scheduler will do is it will open and reload and save your app.
I need to work on as per joining date after every 30 days mail sending.
if you want to send the emails to personel mails like gmail,yahoo.............
You need to provide the correct server address and portno.
If suppose an employee who is working in a company and the company might tie up with yahoo for using thier server
Yahoo will provide a particular serveraddress(eg:smtp.bizmail.yahoo.com,etc) and respective portno(eg:20,etc)
If you provide these details the mail will approach the server and authenticate there and finally it will sent.
So, please check the details once again.
i gone to document setting->trigger->Onopen->edit action...
there i have put all action that was used inside button.
after opening the alertmail.qvw it select the person to whom he has to send mail but it does'nt send it.
I am attaching qvw also for u..
Thanks for response
I was testing using my own mail address in the employee info.
See screen shots I have my portal info in user preference and when I test from there I receive the mail, but when I press the button on the sheet I do not receive the mail
Am I missing something ?
Now check the attachment i have modified your file.
You used fieldevent triggers also that is why you faced the problem.
Don't need those triggers.
See the attached image and follow the settings like that.
As per your screen shots you miss your UserID and Password fields.
Hope it helps you.
See the test mail works from the user preferences ( I have XXX over the company name in the screen shots)
All the mails which I want to send is to
anne.e.duffy@123( which is the address as set in the script) .ie
The server address is
Not sure if there was somewhere else that I also needed to change
Apologies for not getting this