I have rudimentary have code which outputs "Compile error: Type mismatch" in the sample attached database. I will need to create an email to a list of addresses from 'tblEmailAddresses'. Also, I need to include data from a query or table ('tblEmailData') into the email's contents. I want to have the email sent to my draft folder before sending.
Please help me put together something which works.