Access Emailmerge to Eudora (Access 2002)

Topic

New Reply

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

Reply | Quote

Replies

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.

 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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote