Sending an Email

[srbooth]

Is there any way to send the contents of a query by email other than using the SendObject. I am having all sorts of problems with security since upgrading form exchange 5.5 to 2003. I used to be able to send without any problems using Outlook 2000. I thought there might be away to do it programically without using the email client Outlook 2000

Thanks

 

[MicroE]

This example exports a report in a Snapshot Format, but you can modify the OutputTo line to export a query in a different format. It illustrates how to send email without using the SendObject command.
http://www.myaccesstips.com/SearchDetails.asp?TipID=7

 

[srbooth]

Could you point me in the direction of what "Please make sure to add the Microsoft Outlook Object Library to your References." means in the artical you linked to.

Thanks again

 

[MicroE]

From the Menu Bar in the VB Editor select Tools > References. Scroll down until you locate “Microsoft Outlook Object Library” and select the check box next to it. Select Debug > Compile from the menu bar to compile your code.