Possible to have a macro running in the background, with a pause in loop?

[peskywinnets]

I have created a macro that when it runs, it generates a VAT receipt (report with subreport) & emails the customer (using some VBA code to cycle through a table)

The problem is when I run it, a whole heap of emails go out at once & I end up on blacklists. What I seek to do is have this same macro run, but with some form of pause in the VBA looping code (therefore say 20 minutes between successive emails going out)....better still if this access macro/process can run in the background so that it doesn't stop me from using access for other tasks.

Can this be done? (sorry if the line of questioning is a bit n00by, but when it comes to VBA code, I'm fairly new & must take baby steps!)

 

[Ranman256]

you cant run it in background, its a single program that does 1 thing at a time.

As for pausing, you can pause between each email, but why? If you need to send 50 emails, let it send the 50. But again, Access does not thread, so you must watch each email go by AND watch it pause, since it cant multitask.

 

[CJ_London]

not sure if it will do what you require, but investigate the form timer event.