Access Query to Outlook in message body

[FeS2]

I have Access 2003 & Outlook 2003. I need to take the results of a query and have it send in an e-mail but not as an attachment, but in the message body. I can get it to do it as an attachment by using SendObject in a Macro. Any help is greatly appreciated.

 

[Blorf]

This is interesting. I would think you would have to open the query as a record set, and move through it, and with each reacord, do a .body = .body & current record.

Something like that.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/