Sending E-mails from Microsoft Access

  ahkid2002 08:47 07 Feb 2003
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 2003

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?