How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36526
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

In MS Access I am trying to send an automatic E-mail from a

This answer was rated:

In MS Access I am trying to send an automatic E-mail from a form.
Thank you for your question, my name is Richard.

First, is the email sending from the form at the moment?

Customer: replied 4 years ago.

Hello Richie

Yes, the button sends the e-mails. Do you want me to send the database to you with the changes I made?

Yes please John

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 4 years ago.

File ID: 846500

ok, so now you just want to press a button and it emails based on if the date is today or not correct?

As you will need to still press a button to start this.

Customer: replied 4 years ago.

No. I need the date to activate the e-mail automatically.

so you are going to leave this program running 24/7?

Customer: replied 4 years ago.

Yes. The database I sent you is only a simple sample. The equipment they are dealing with are large and dangerous if not properly kept up. The boss wants to make sure that when a compressor inspection date is due, the two supervisors will be notified to completed the inspection on time. He has to deal with OSHA if they are not done on time. It is important to send the e-mails on the various dates that the inspection are due.

ok, my advise John is to have someone open the form and click a button once a day. The reason is, you can only run once form 24/7 as it ties up the program, plus it will complicate any future expansion of the program.

Is it possible to have someone click a button once a day and it then sends out the emails.

Or, knowing this, you still want it automatic?

Please let me know.

Thank you
Customer: replied 4 years ago.

I have as many as 10 databases for each facility and as many 40 pieces of equipment. It makes it impractical for someone to press the buttons every day. I would like to try automatic and see how it goes.

this is done John

You can download it here

When you run the compressor 1 form, it auto runs in the back ground.

Let me know if you have any difficulties please

Thank you
You need to put everything into one form John, then this solution is ok, else for each form you need to put it in its own database, and that is not the way you wish to go.

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions