E-mail user with two seperate fields

Dallas_Spohn · May 8th, 2009, 02:31 PM

I have a table with employee info, the name is in two separate columns(first and last). I would like a way of clicking on a button next to the persons name and it emailing them.
Between the first name and last name is a period and then filling in the @soandso.com part.

Is this relatively easy to do?

****please forget this thread. Exchange server finds the user without a full address.

SerranoG · May 13th, 2009, 10:06 AM

When you click the button, the e-mail address (in your case) is simply the concatenation of the two fields plus the rest of the address. So assuming the first and last names were in textboxes called, e.g. txtFirstName & txtLastName, then put this code somewhere on the button's click event code.

Code:

Dim strEmail as String, strFirstName as String, strLastName as String
 
strFirstName = Trim(Nz(Me.txtFirstName, ""))
strLastName = Trim(Nz(Me.txtLastName, ""))
 
If Len(strFirstName) = 0 Or Len(strLastName) = 0 Then
    MsgBox "User Name is not properly entered.", vbCritical, "Invalid Name!"
Else
    strEmail = strFirstName & "." & strLastName & "@soandso.com"
End If

Dallas_Spohn · May 13th, 2009, 11:34 AM

thank you...