Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    68

    Unanswered: Please Need Help For Email Form Urgent

    PLease help, i have one day to do this before my school project is in. I need an emial form that will automatiacally send out a defautl email message by a click of a button by taking the email address of the current form "Members", can anybody please help? i dont mind if the whole process isnt in access, Outlooks fine.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    search this site for "izymailer" (used to be http://dbforums.com/showthread.php?threadid=889998 but i didn't check if that still works).

    that gets you (my flavour of) a generic outlook mailer. save the code in a global module called anything you like ...if you are stressed on time don't worry about the details inside the code (in principle you should not use code you don't understand, but also in principle you should not have left your project to the last second before midnight)

    then you need a form that has a mail address, body text, and subject boxes. call izymailer with the values from your form using a button:

    private sub YourButton_Click()
    if izyMailer(False, addressBox.value, subjectBox.value, bodyBox.value) then
    msgbox "your mail got sent"
    else
    msgbox "ooops!"
    endif
    end sub

    izy
    currently using SS 2008R2

Posting Permissions

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