Search step by step in table and populate variables.

[Peter Adema]

I have one table with E-mail addresses.
Via a loop I want to go through the table record per
record and store the mailaddress in a variable. Then send
the mail.

Dim Mail

DoCmd.GoToRecord acDataTable, stDocName, acGoTo, acNext
.....store the mailaddress in variable Mail.....
DoCmd.SendObject acSendQuery, "q_aantal1", acFormatXLS,
mail, , , "Current Spreadsheet of Employees", , False

 

[Alex Dybenko]

Best is to open recordset
look at this sample:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231797&Product=acc