Send email (without report attached) from Access Form

[maca9]

Hi

I am having trouble sending an email from access unless I am attaching a report.

Using the sendreport command I am able to have a button automatically attach the report and open the email and address it with a field from the form.

But when I want to simply send an email with out a report i have having problems.

I am trying to create a button which when pushed will open mail message and send it to the person in one of the fields.

The next tricky bit is the address. The field will contain John Smith.

But the address needs to read john.smith@anywhere.com

Any help would be awesome.

Thanks

Scott

http://www.vegajewellery.co.nz

Diamond Specialists

 

[THWatson]

Scott
Do you have a control that contains the e-mail address?

If so, the following opens an e-mail message in Outlook Express, and then you can put in the subject, message text, and whatever...

strTemp = Me.YourEMAILControl
If strTemp = "" Then
Call MsgBox("There is no e-mail address for this person.", vbExclamation, "e-mail address check")
Exit Sub
End If
DoCmd.SendObject , , , strTemp

Tom