Send Access Table Using VBA code by outlook

[vishan_rana]

Dear All Gurus,

I have a access having with table name "Daily_RTO" i want to send it on email "vishan.uk@gmail.com" by access VBA code using outlook email system.

Im new to VBA codes, pls suggest me full code of sending Access Tables and Select Queries to given email addess.

Thanks & Regards
Vishan

 

[alansidman]

Here is one way to do it. This is based upon Access 2003, but you should be able to update as necessary for later versions.

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2