Search step by step in table and populate variables.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-mail query to recipients in table - performance and security 1
VBA to increment all records in a table by 1 4
Creating a Lookup Table Using Do...Until Loop 2
Selecting next record in dynaset and assigning to variable 1
Sending E-mails in macro;No memory 4
Loop through table & gather e-mail address 4
Email 180 column table/view dilemna 0
Using Data from a Table in Variables and Loops 1

Top