Output report to body of email

[SPRTRMP]

I have 2 issues with a report that I am trying to send in the body of an email to different recipients:
First, I need to export the report to the body of an outlook email message. The report is very simple text with no tables\lines or anything like that, so there is no real need for HTML formatting.
Second, I would like the "To:" field in outlook to be populated from an "email" field on a form that is open when the "send email" button is clicked. In other words, I want Access to pass the contents of a field to the "To:" line in outlook, somehow.
I am a new Access user with practically NO coding experience: please be gentle.

Thanks for any help.

 

[pbaldy]

The simplest way to send an email is probably SendObject, more info in VBA help. You can use a reference to the form for the "To" argument. Several methods discussed here (second section):

http://www.granite.ab.ca/access/email.htm

As to getting the report into the body of the email, that will be a little trickier. This should get you started:

http://www.granite.ab.ca/access/email/formatted.htm

If the report only returns a single record with your text, you can probably just use DLookup on the underlying query.