Form and Command button refresh?

[bbno4]

I've created a command button that looks to a macro that will run a query and
fire off an e-mail that prompts me to enter an e-mail address(es). When I
click on the command button again, it does nothing. In order to send another
e-mail, I need to close down the app and restart. Is there any type of
re-fresh for the command button to work consecutively?

Thanks

 

[Steve Schapel]

Bbno4,

Can you give the details of the macro please?

 

[bbno4]

Uses SendObject to send an e-mail with an Excel file attached. Will prompt
for e-mail address(es).

Thanks!