I'm trying to make a macro that will search out an email address from a specific cell in a sheet and then send a pre-made email message to that address. It would be best if it used a script that allowed for sending without using outlook. (I've read a lot of codes that use CDO?)The message of the email will be on a hidden sheet in the workbook. Any help?