Sending Email From an Access Database

This is a example of how to send a smtp email using a Access Database as the source of the Sender,Recipent,subject and Body data of the email. Setup: To use the example create a System DSN using the MS Access driver and point to the file path of the attached database. Next open the database and add you Recipents and From addresses then your subject and your test or html body. If you wish to use html just enter the raw html into the body cell. To run the script you will need to copy the code example to your drive and give a *.vbs extension. To run you can use the command "cscript FileName.vbs" or use a batch file to lauch form the task scheduler.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.