e-mail subject line

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

I have had a request to include the results from three
fields on a form into the subject line of an e-mail that
is created from the form. Any ideas? I can get on field to
populate but when i try and write a line of code to
include all three fields I get a blank subject line.

Thanks
Mick
 
Mick,
Given the SendObject syntax....
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]
You can use concatenation to place the value of 3 fields in the SUBJECT
argument of the SendObject function.
ex.
[Myfield1] & " " & [Myfield2] & " " & [MyField3]
in the Send Object Subject should place the value of all three fields
(seperated by spaces) in the email subject.
 
Back
Top