Im trying to create an email form in my cutsomer contacts database. The form includes a [To] field, a [message] field and a group of tick boxes which will allow the user to select PDF files to attach to the email. I have a few question regarding this:
1) Does the form need to be linked to a table? I don't really need to save the emails especially if i use outlook to send the email as they will be stored there in the sent folder.
2)My [Message] field on the form is a text box set to rich text format, however, how do i enable the return key so that it doesn't move to the next field but adds a carriage return instead?
3)This is the main one - how would i email from this form? I have used email in access before, but mainly for inhouse emails/notifications. how would i attach the checked PDF files to the email?
I know this is a lot to ask, and i'm not sure if it can be done at all. I hope someone can point me in the right direction and i look forward to hearing from you.