I have an attendance database that I would like to send a weekly or daily email to mgmt/supervisors to tell them who is out of the office and maybe why.
The reason for the email is the traveilng mgmt and supervisor have blackberry's that have email access but not database access so they would like to know who is out and why while they are on the road.
I have an associate profile doc in the database that tells who each associates supervisor is. I have a view created that is sorted by Date and then employee Name, sup Name, type of time off, and duration. Where i am stuck is how to generate the email to send to the supervisors.
Any help would be much appreciated!!!!