How to creat exist form on screen

[meobeou]

Hello friends

My boss has to to send 50 reports via outlook email to two different groups (25 each group). For doing this, He has to fill all columns and attach the report. He asked me to create something which make his work easy.

I made a small MS Access 2007 mdb. I am using a macro to send his reports and give 25 email address in single email. Then I created a form and put two command buttons to run this macros. This form open as Maximize and by clicking the button, it starts to sending email. After one address it ask to allow (picture attached) second address and so on. When it is clicked for next email, my Maximize form disappear and it shows Desktop.

I want my form keep and still Maximize, Access Window should not appear and desktop should not be seen. if any one could help.

Secondly, is there any way that all emails go with one click and I should not keep clicking for 25 times.

Thanks for help.
Lee!

[NeoPa]

Hi Lee.

A couple of problems. First, your picture is NOT attached :-( We can probably guess which pop-up it is though.

Second, I would guess that, like many before you, you've got about as far as you can go using macros. Not an expert on macros as they're basically rubb... Let's just say they're severely limited and limiting.

I suggest you look at coding this in VBA instead. More people here will be able to help you that way.

Personally, I very rarely play with Outlook, but from what I've read it seems you can create a new email for review without any of the pop-ups. The rationale to that is that you are prompting the operator only. They still decide to send or not. Trying to send directly is when it starts throwing up the messages.

No idea what happens using macros. Would never go there anyway.

[twinnyfo]

meobeou,

Welcome to Bytes!

If you plan to use Outlook, please review this thread on sending E-mail via VBA. There are many ways to implement this throughout your projects.

Hope this hepps!