Automating email in Access XP

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Does anyone know how I can automate sending emails to
recipients in an Access 2002 table? I can do this with
recordsets in Access 97 (starting with Dim db as Database,
as described in Microsoft Knowledge Base Article -
318881). But In XP/2002 I'm lost. Can anyone help me on
this?
Thanks.
Chris
 
The code listed in KB 318881 should work ok on Access 2002. There are a
couple of additional requirements; however ...

1. You must manually set a reference to the Microsoft DAO 3.6 Object
Library. Access 97 set it for you but Access 2002 does not. If you do not
use ADO in our application, you can delete that reference; or, you can move
the DAO reference above the ADO reference in the list. (Since you may one
day use both ADO and DAO in the same application, it's also a good idea to
get in the habit of dis-ambiguating your references; i.e.,

Dim db as DAO.Database
Dim rs as DAO.Recordset

2. If you are using early binding and have a reference set to the Microsoft
Outlook 8.0 Object Library, you'll need to re-set it to the library for your
current version of Outlook if that has also been upgraded. Outlook 2002
would use the 10.0 object library


hth,
 
Back
Top