Sendobject to addresses in a query

[iisjman07]

Hi, I'm designing a database for a computer shop and one of the features is a report showing all the customer information. I put a button up the top of the report labelled 'Mass Mailout' and want it to send an email to every address listed. I created a query of just email addresses with the criteria

<>""

to remove any blank fields, and earlier in my project I used a sendobject to one address in this fashion:

DoCmd.SendObject _
    , _
    , _
    , _
    Me.Text1, _
    , _
    , _
    Me.Text3, _
    Me.Text5, _
    False
MsgBox ("Message Sent")

My question is how do I get the 'to' field in outlook to list all the email addresses in the query?

 

[jdraw]

You might get some ideas from this free video tutorial
http://www.datapigtechnologies.com/flashfiles/accesssendemail.html