Sending E-mails from Microsoft Access

  ahkid2002 08:47 07 Feb 03
Locked

Hello All

Is there a way of sending an e-mail automatically in Microsoft Access. I have this database of Toners and Ink Cartridges and when somebody has a Cartridge i enter it on the database, so is there anyway that when the number left is 1 the Program automatically sends an e-mail to the supplier.


Hope you can help

Steve

  harristweed 10:01 07 Feb 03

Hi Steve - Have a look at the macro SendObject. This will send an email.

You will need to identify when the level reaches 1 item and activate the macro then. The best way to do this may be at the time the quantity field is updated, but without knowing your database and how this is done, I can't say.

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now