outputting a embedded rich text email ?

[andrewvranjes]

hi fellow accessers!


can anyone point me in the right direction on this issue.

I have a query which needs to be run every hour during business hours.

I have setup a scheduler to run this.

The query has a marco that emails the query output to the call centre at my work. Which is exactly what i require, but my collegues are asking that the email be embedded in there emails so that instead of recieving a emial with a excell attachment, that the query be displayed in there outlook msg's rather than them having to open a attachment to view the data.

I have tried changing the output file options between rich text, html, etc etc to no avail, it still comes as an attachment.

Is there anyway that i can make this outputted data embedded in the email without having to resort to visual basic?

thanks mates

Andrew