Sending Multiple Emails: Bypass Pause in code

[EhWot]

Hi all,

This is only a small thing but is driving me nuts as I can't seem to solve it.

I've written some code that cycles through a list of names. For each curent name, a query is created using the current name as criteria and an Email is sent to the address associted with the current name with the Query as an Excel attachment.

Currently, the user has to click send before the next Email is created, my question is this:

How to I get the code to populate the screen with ALL the Emails at the same time? I.e. 7 Names will populate the screen with 7 Emails?

I'm using

DoCmd.SendObject acSendQuery, "TempQueries", acFormatXLS, Email, , , , , True

Is there a 'Resume' type command I can prefix this with?

Any help would be greatly appreciated.