Emailing from a form

N

Nicole

I'm using the following code to send an email:

Dim SendTo As String, MySubject As String, MyMessage As String

SendTo = "(e-mail address removed)"
MySubject = "Update from MP-200"
MyMessage = "An MP-200 update has been provided for the project" & " " &
Me.Proj_Name
DoCmd.SendObject acSendNoObject, , , SendTo, , , MySubject, MyMessage, True

In the "MyMessage" portion I want Access to tell the email which record the
message is coming from. The field in which this information is carried is
two words long. What I have above for MyMessage won't even compile and I
don't have the slightest clue of what to do. Help please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bold Code 2
Emailing information about a specific record 4
Send email from access form 3
Email Help 17
SendObject Email 2
Dlookup invalid use of null 6
Email issue 0
DLookup Syntax for text criteria 3

Top