Prepopulate outlook email from Access fields

[raboo2u]

Hi Everyone,

I have an access Database where I have a form that I want to prepopulate an outlook email with the following information. I have a control button that I will click on that should open the emial with the following fields populated.

To:

Table - person
Key - personid
field - emailaddress1

From: Always my email address

Subject:

Table - TitleName
Key - TitleNameID
Field - Title

Message Body

1. Table - Status
Key - StatusID
Field - StatusDesc


2. Table - TitleName
Key - TitleNameID
Field - NameDescription

3. Table - Call
Key - CallID
Field - Solution

How do I proceed to get the fields filled in?

Raboo2u