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

How to make exist form on screen

P: 71
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.
Irshad Ahmed

Attached Images
File Type: jpg Pic.jpg (47.9 KB, 210 views)
Sep 1 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
I am using a macro to send his reports
Macro -- You are stuck with what you have. Macros are very limited in this respect.
VBA -- post your code formatted with the [CODE/] tool
these are not the same thing in Access

See the insight article and the subsequent Application Automation article linked to therein
home > topics > microsoft access / vba > insights > sending e-mails via outlook - one developer's approach

there are also dozens of threads here on covering various aspects of doing this very thing.
Sep 1 '18 #2

Post your reply

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