Les wrote:
Hi all, i am not a programmer but a dabbler, i need to do the
following.... The user must enter on a form a monetry amount, a
project number and his name. I would like him to then click on a
button and a standard e-mail format with the inputs added to the e-
mail at certain places must be sent to a certain person, who will not
change... Any help would be appreciated.
As Keith noted, SendObject will meet your requirements.
One of the arguments you can pass within SendObject is the EmailBody
(messagetext). You can construct some sort of message as a string for
the email body.
strBody = "Dear " & Me.FirstName & ":" & vbNewLine & vbNewLine &
"This order " & Me.OrderID & " confirms our ..."
Also, you can create a report and send the report also as an attachment.
If you do create a report, make sure the report is one where the
recordsource filters for the record you are sending the message for.
Let's say on the calling form you have a field called OrderID. Your
report should reference the OrderID on that form. Also, you will need
to save the record prior to sending the email because it really isn't a
record in the database until it is saved.