Results 1 to 2 of 2

Thread: Send email from form based on information on the from

  1. #1
    Join Date
    May 2011
    Posts
    2

    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!

  2. #2
    Join Date
    May 2006
    Posts
    407

    Answer - in DB within the zip file

    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.

    Any questions, please ask.
    Vic Rauch
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •