Search step by step in table and populate variables.

  • Thread starter Thread starter Peter Adema
  • Start date Start date
P

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
 
Back
Top