Results 1 to 2 of 2

Thread: Email a Record

  1. #1
    Join Date
    Jan 2002

    Question Unanswered: Email a Record

    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.

    Please Help


  2. #2
    Join Date
    Dec 2001


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts