Send email from form based on information on the from
Not sure if this is possible but here is what I want to do.
My form is named "NotestoStaff" and it contains the following fields:
ID (an auto field)
Date Opened
Status
Note To
Note From
Re
Message
Once the fields are filled in I want to click send (a command button located on the form) and the Note to field will populate the email address in anew outlook email, the re field will populate the subject line, and the message field will populate the body of the email.
Is this possible. I prefer this than sending an object, but if this is not possible may have to resort to sending the object.
Any information regarding this is greatly appreciated!
I have attached a database I wrote to send a group of emails based on criteria within the table of email names and addresses. There is only one form in this database. Its purpose is to create the email message and subject, then select the criteria used to select recipients, then have a button to click that would send the email, using Outlook. Outlook will produce an error message, requesting autorization to use the contacts list to find the email addresses being requested. Just answer yes to that message, and your email will be send.