Stopping Outlook Express Email in Access VBA

[VickyC]

Hello to all

I use Access VBA to send bulk emails (using DoCmd.SendObject in a Do...Loop) to members of my daughter's sports club through Outlook Express. As each email is sent, an Outlook Express dialog box appears showing a progress bar and buttons to STOP and to show Details.

If I click STOP, Outlook Express just proceeds with the next email address. Even if I close this box, the emailing just continues.

How can I use code to STOP the Outlook Express program when the STOP button is clicked? When STOP is clicked in the Outlook Express dialog, I need to exit my Access Do...Loop.

thank you
Vicky

 

[assets]

Internet explorer contols email programs. It gave us problem with groupwise. lok at the setting there.

Never give up never give in.

There are no short cuts to anything worth doing