• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3630
  • Last Modified:

Access 2010 Auto send query results via email

Hi
I have some simple query's that I would like to run and send via email from Access 2010
I have created a macro using the EmailDatabaseObject. It all works as expected, but Outlook has to be open for it to run. Is there a more sophisticated way to set this up? I'm looking to email reports on a certain day/ Time to users, without having to have outlook open.
0
George_Milton
Asked:
George_Milton
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
There are several methods:

1. Using something that talks directly to am SMPT mail server, like BLAT or vbSendMail

2. Using CDO.

3. Using a 3rd party control or a commercial product like FMS, Inc's total mailer.

 Personally I like vbSendMail:

http://www.freevbcode.com/ShowCode.asp?ID=109

 Although it shows it being for VB6, it drops right into Access and only requires that the one DLL be referenced.

 Many use BLAT as well and both are free.   With either, that's the simplest you can get with sending e-mails and neither requires any other software installed on the client.

Jim.
0
 
Luke ChungPresidentCommented:
Take a look at our Microsoft Access add-in and VBA libraryTotal Access Emailer. It's the most popular Microsoft Access email program.

Total Access Emailer uses an SMTP server so it bypasses the MAPI/Outlook issues.

It includes an interactive Access add-in that runs within your Access database environment. That lets you setup your email blasts using your tables, queries, reports, etc. You can send personalized emails to each contact including attachments of PDF files filtered for each person.

The Professional Version includes a VBA library that lets you add email blasts in your VBA code.

Hope this helps.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now