E-Mailing a report

[Pete]

Im using access 2000 and i need to send a report via e-
mail. I have worked out how to send it as an attachment
using the SendObject macro command but i need to send it
as the body of the e-mail if possible instead of as the
attachment. The report has pictures in it if that makes a
difference. Anyone know a way of doing this?

 

[judith]

I recently posted a question on emailing from access and
got no reply so I suspect this is a bit of a hazy area. I
have also been playing with the sendObject and as you say
it will send an attachment but not a lot else. I have
used the snapshot format and that works well for me.

Do you know a way of sending to all recipients in a table
without resorting to VBA and looping through the list?

Good luck

 

[Pete]

Not as yet, i was working on getting it to send as the
body first : ) But thats something i will need to use
later so i could do with finding out. If i do i will repost