Emailing information about a specific record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
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 name in which this information is carried
is
two words long. What code can I use in the MyMessage string that will make
this happen?

Thanks, Nicole
 
I assume you are doing this from a button on a form?

What does the field you want to include in your email contain?
What is the name of this field?

Steve
 
OK try this:
MyMessage = "Ref:" & Me![Proj Name] & Chr$(13) & Chr$(10) & "An MP-200
update has been provided for the project"

Steve
 
Exxxxxxcellent AND WooHoo!

Worked like a dream.

SteveM said:
OK try this:
MyMessage = "Ref:" & Me![Proj Name] & Chr$(13) & Chr$(10) & "An MP-200
update has been provided for the project"

Steve

Nicole said:
The field just contains a string of text. Its name is Proj Name.
Click to expand...
Click to expand...
 
Back
Top