How to generate an email using Access.

[Guest]

I am a novice user of access. I am currently building a "Leads" database for
the compnay I work for. I am going to need to generate emails to our
regional sales manager containing information for leads in there area.
Basically what I am trying to do is have a button on a form that will open an
email with the data in the body of the email, the user could then select the
regional manager from there address book.

I have built a couple databases before, but have never figured out how to
automate emials with data in the body.

Any help is greatly apprectiated.

Barry

 

[Guest]

Barry,
You could create a report based on the results first and email that using
the SendObject method in VB or a macro. Sending in snapshot format is my
preferred way, but the recipient will require snapshot viewer installed on
their machine.
Hope that helped.