There's probably 2 questions in your message but honestly lambda will not be too complicated to setup.
1) Send email from Amazon platform:
you mention SNS, SES and SQS so lets look:
- SNS : Amazon Simple Notification Service
Send mobile notifications, emails and/or SMS messages. In your case (email) as its notification based you need the subscriber to specify email as the protocol of receiving notification. Probably not what you're looking for
- SES : Amazon Simple Email Service
With Amazon SES, you can send transactional email, marketing messages, or any other type of high-quality content to your customers. Probably what you're looking for
- SQS : Amazon Simple Queue Service
Store data for future processing in a queue. The lingo for this is storing "messages" but it doesn't have anything to do with email or SMS. SQS doesn't have any logic, it's just a place to put things and take things out. (from https://www.expeditedssl.com/aws-in-plain-english).
Look at his Q&A with the question and answer you'll have a fully setup lambda to send email from AWS lambda using SES
2) Schedule the lambda to run at specific time
Back in october 2015 Amazon introduced Scheduled Functions (Cron) so
You can now invoke a Lambda function on a regular, scheduled basis.
You can specify a fixed rate (number of minutes, hours, or days
between invocations) or you can specify a Cron-like expression:
