send email to multiple people from access

[okan]

Hi everyone.

Is it possible that send same email to multiple people in table/form anyone with the same draft.

1.Private Sub Command20_Click()

2.Dim body As String

3.body="hello all"
4.If Me.ePosta <> "" Then
5.DoCmd.SendObject acSendNoObject, , , Me.ePosta, , , "hi", body, True
6.End If
7.Exit Sub
8.email_error:
9. MsgBox "An error was encountered." & vbCrLf & "The error message 10. is: " & Err.Description
11. Resume Error_out
12. Error_out:
13. End Sub

this code sends mail only one person. i want to send same mail to whole people.
i mean that it must be shown that to: [e-mail];[e-mail];[e-mail] ......

like that

thanks

[MMcCarthy]

Hi everyone.

Is it possible that send same email to multiple people in table/form anyone with the same draft.

1.Private Sub Command20_Click()

2.Dim body As String

3.body="hello all"
4.If Me.ePosta <> "" Then
5.DoCmd.SendObject acSendNoObject, , , Me.ePosta, , , "hi", body, True
6.End If
7.Exit Sub
8.email_error:
9. MsgBox "An error was encountered." & vbCrLf & "The error message 10. is: " & Err.Description
11. Resume Error_out
12. Error_out:
13. End Sub

this code sends mail only one person. i want to send same mail to whole people.
i mean that it must be shown that to: [e-mail];[e-mail];[e-mail] ......

like that

thanks

Assuming Me.ePosta is where the email address is stored do you want to send it to everyone in here or just some of them.

[okan]

ePosta is a field which stores email addresses of people. code is trying to get mail address from this field and connect to outlook and send body to the receiver. this code is ok for sending mail only choosen email, but i have for example 50 user and i want to send the sample email to all of them. Is there a way to make it?

[MMcCarthy]

ePosta is a field which stores email addresses of people. code is trying to get mail address from this field and connect to outlook and send body to the receiver. this code is ok for sending mail only choosen email, but i have for example 50 user and i want to send the sample email to all of them. Is there a way to make it?

You say you have an example of 50 users but is this all the users in the table or is there some query to decide which users will be receiving the email?