Email Access Report as "Body"

[Dan2kx]

Hello to all,

i have a new interesting problem to solve....
i have a report that i would like to email to a list of users,
the report is a full page document and is personalised to each user (basically) more than one user can have the same email address so i will create a recordset to list all of the users (who need the email) and loop through the users and send to the associated email address, i have a few problems

1)currently the report is set up to list all the reports in the same report.... make sense? so i would need to send only the correct page... is that possible? if not then i will have to alter the reprt to build using the info from my aforementioned loop.

2)the biggest obsticle is that i want the report (sent as html) to be the body of the email, i have tried this:

DoCmd.SendObject acSendReport, "report1", acFormatHTML, EmailAddress, , , "Subject:____", "report1"
 

this opens the email to be edited (which i dont want to do) but the report does send as the body this way

so i tried this (to NOT edit)

DoCmd.SendObject acSendReport, "report1", acFormatHTML, EmailAddress, , , "Subject:____", "report1", false
 

which does send the email straight away... but sends the report as an attachment... any ideas?

thanks for ya help guys

Dan Out

[NeoPa]

Denburt,

This is not the same thing at all. Microsoft links are fine. They are not there to advertise their site. They are, after all, the vendor of the software that we're all working in.

What was removed was a link to the poster's own web site where they'd posted the code that should have been posted in here.

I'm glad you asked though as it illustrates the situation more clearly.
In short, no edit required :)