To Email From Access 2007

[foreigner]

I have created a form in Access, which has fields like name, sirname, email, city, country....

All i want is to send emails to friends with filtering city. Like i can email all of them or select a city. My "city" field is shown on form with drop down menu.

Is there such a command script which can do that and open outlook automatically with selected emails in "to" field ?

Thanks in advance :)

[foreigner]

I found this and made a command button :
--------------------------------------------------------------------------

Dim stDocName As String
Dim stLinkCriteria As String
Dim Subject As String
Dim Message As String

If IsNull([E-Mail]) Or ([E-Mail]) = "" Then
MsgBox "This Person Has No E-Mail Address"
Exit Sub
Else
stLinkCriteria = Me![E-Mail]
stSubject = ""
DoCmd.SendObjec t acSendNoObject, , , stLinkCriteria, , , stSubject
End If
---------------------------------------------------------------------------

But this sends individual emails to selected person on form.

How can i edit this script to send emails to all persons which are located in my "e-mail" field?

And is there a way to filter with another field like "city" or "job" ?

Thanks in advance :)