I want to use xp_sendmail but somehow it doesnt work as i dont have SQL Agent mail set up. SQL mail needs exchange server but we have Lotus notes for our emails. Is there any other way i can get xp_sendmail work? Any help will be greatly appreciated.
TIA