e-mail

I have a visual basic program who's connected to an access database.

In a table in the database there is an e-mail field...

I want to generate an e-mail.

Is there anyone who has any ideas?

Do you mean:

VB Code:

Shell "start mailto:[email protected]"

?

yes but i also want to give the body text with it and let it send automaticallys

yes but i also want to give the body text with it and let it send automatically

Then I don't know...

do u want to send it thru outlook?

This is a code I use myself. It sends automatically throught Outlook, but you see the connecting form.

On Error Resume Next 'may be connected already
MAPISession1.SignOn

With MAPIMessages1
.SessionID = MAPISession1.SessionID
.Fetch
.Compose
.MsgSubject = "My e-mail"
'MAPIMessages1.AttachmentIndex = 1
.RecipAddress = "[email protected]"
.RecipDisplayName = "Webmaster"
End With


For this, you need a Mapisession and a mapimessages on your form

Here's an example from PSC.
http://www.planetsourcecode.com/vb/s...=5308&lngWId=1