I am using an access database to view "invoices" (an invoice being the viewed record). I would like for the user to be able to click a button on the menu bar that will email the "view" of the invoice to someone. We use Lotus Notes R5 as our email client. I would like the email to look somewhat like the view of the invoice either in a .doc file or something similar.
I had to do the same thing a few weeks ago. Microsoft's Knowledge base has a great article that gives you the code you need to accomplish this easily. The article number is Q145787. In the article, they explain how to Fax a record, all you need to do is change the code a little bit to make it work for you.
For example, when the code uses "DoCmd.SendObject acReport, "Invoice...", Just swap the fax number for the email address.
I know this works for Outlook, haven't tried it with Notes. Let me know how it works.
If I have some time later, I'll try to post the code for you.