Entering email address puts a semicolon instead of a comma

[Guest]

Hi all,

Hoping you can help. I have a subform that has a command button that starts
an email message. It is supposed to take the name on the main form and put
it into the To field of an email message. It does this except that it puts a
semi-colon instead of the comma I need. Our email system uses this
convention to email people: "LastName, FirstName".

Here's what I've entered so far in the event procedure:


Private Sub cmdSendEmail_Click()
Dim strEmailAddress As String
Dim strSubject As String

strEmailAddress = Forms!frmContactDataEntry![LName] & ", " &
Forms!frmContactDataEntry![FName]
strSubject = Me![IssueName] & " - " & Me![IssueTransDate]

DoCmd.SendObject acSendNoObject, , , strEmailAddress, , , strSubject


The subject is in the subform but the name is messing with me. Help!

Thanks!
Chris

 

[Terry Kreft]

Have you tried

strEmailAddress = """" & Forms!frmContactDataEntry![LName] _
& ", " & Forms!frmContactDataEntry![FName] & """"

This will quote delimit the e-mail alias.

 

[Terry Kreft]

Have you tried

strEmailAddress = """" & Forms!frmContactDataEntry![LName] _
& ", " & Forms!frmContactDataEntry![FName] & """"

This will quote delimit the e-mail alias.

 

[Guest]

Works perfectly! Thanks Terry!

Have you tried

strEmailAddress = """" & Forms!frmContactDataEntry![LName] _
& ", " & Forms!frmContactDataEntry![FName] & """"

This will quote delimit the e-mail alias.


--

Terry Kreft

Hi all,

Hoping you can help. I have a subform that has a command button that starts
an email message. It is supposed to take the name on the main form and put
it into the To field of an email message. It does this except that it puts a
semi-colon instead of the comma I need. Our email system uses this
convention to email people: "LastName, FirstName".

Here's what I've entered so far in the event procedure:


Private Sub cmdSendEmail_Click()
Dim strEmailAddress As String
Dim strSubject As String

strEmailAddress = Forms!frmContactDataEntry![LName] & ", " &
Forms!frmContactDataEntry![FName]
strSubject = Me![IssueName] & " - " & Me![IssueTransDate]

DoCmd.SendObject acSendNoObject, , , strEmailAddress, , , strSubject


The subject is in the subform but the name is messing with me. Help!

Thanks!
Chris

 

[Guest]

Works perfectly! Thanks Terry!

Have you tried

strEmailAddress = """" & Forms!frmContactDataEntry![LName] _
& ", " & Forms!frmContactDataEntry![FName] & """"

This will quote delimit the e-mail alias.


--

Terry Kreft

Hi all,

Hoping you can help. I have a subform that has a command button that starts
an email message. It is supposed to take the name on the main form and put
it into the To field of an email message. It does this except that it puts a
semi-colon instead of the comma I need. Our email system uses this
convention to email people: "LastName, FirstName".

Here's what I've entered so far in the event procedure:


Private Sub cmdSendEmail_Click()
Dim strEmailAddress As String
Dim strSubject As String

strEmailAddress = Forms!frmContactDataEntry![LName] & ", " &
Forms!frmContactDataEntry![FName]
strSubject = Me![IssueName] & " - " & Me![IssueTransDate]

DoCmd.SendObject acSendNoObject, , , strEmailAddress, , , strSubject


The subject is in the subform but the name is messing with me. Help!

Thanks!
Chris