By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,147 Members | 744 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,147 IT Pros & Developers. It's quick & easy.

How to creat exist form on screen

P: 1
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.
Jan 22 '19 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,494
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.
Jan 22 '19 #2

Expert Mod 2.5K+
P: 3,284

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!
Jan 22 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.