help with ms access send email vba code (1 Viewer)

[Nancythomas]

Please help I just cannot get this right
I need to send email to a group of people with the same exchange/domain address (such as "@Gmail.com"), the email address name will be taken from the table and added to @Gmail.com.
My Database, I need to send email messages to all the selected employees.
When the user’s click the send email button, it should send emails to all the mobile numbers in the form. I don’t know where to put the domain address example 045623232@gmail.com.
@gmail.com is common for all the numbers but where do I add this.
Attached is the sample database and the start form is FrmEmail,
Please help!!

 

[June7]

I have never heard of using a phone number as email address. Where did you get this idea?

There is an EmailAddress field in table. Would have been nice to see some dummy values in it.

Might find this of interest http://www.accessforums.net/showthread.php?t=77023

 

[Gasman]

Are we talking about this code?

   'Build the Recipient List
    With rst
      Do While Not .EOF
      strTO = strTO & "[QryDivisionMobileNo]@PCSMS.COM.AU" & ";"
      .MoveNext
      Loop
    End With

if so, try

   'Build the Recipient List
    With rst
      Do While Not .EOF
      	strTO = strTO & rst![QryDivisionMobileNo] & "@PCSMS.COM.AU;"
      	.MoveNext
      Loop
    End With

HTH