Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Vancouver, BC, Br. Columbia, Canada
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Emailmerge to Eudora (Access 2002)

    Does anyone know if I can create an email merge to Eudora? John Hutchison, if you're reading this, you sound like a Eurdora-kinda-guy! Tell me what you know.
    Gwenda

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access Emailmerge to Eudora (Access 2002)

    Yes I use Eudora.
    I use docmd.sendobject to send email using eudora. Do you want to just send a message to each person, or attach some database object to the message?
    Broadly, what I do is open a form that has text boxes for the subject and message of email message, and some way of selecting who it is going to.
    Then I create a recordset of the recipients and loop through the recordset and send the message to each person in it.
    <pre> Set rs = db.OpenRecordset(sql, dbOpenDynaset)
    rs.MoveFirst
    Do While Not rs.EOF

    If Not IsNull(rs!EmailAddress) Then
    If fnValidateEmail(rs!EmailAddress) Then
    DoCmd.SendObject acSendNoObject, ,, rs!EmailAddress, , , Me!Subject, Me!Message, True
    End If
    End If
    </pre>

    Regards
    John



  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Vancouver, BC, Br. Columbia, Canada
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Emailmerge to Eudora (Access 2002)

    Thanks John - I'll try it and let you know how it goes. BTW, what's in your fnValidateEmail function?
    Thanks,
    Gwenda

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access Emailmerge to Eudora (Access 2002)

    Sorry i should have either explained that or left it out.
    fnValidateEmail checks that the email address is reasonable:
    i.e. it has an @ in it, (and not at either end perhaps, can't remember)
    it does not have any spaces
    it has at least one . (period)
    the . is not at the end
    I think that is about it.

    I think that similar functions have been posted here in the past.

    I use the same function in the after update event for any controls that are used to enter or edit email addresses to validate them as they are entered.
    Regards
    John



Posting Permissions

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