Hi,

my code runs well, after when i added in my body message. An error occure, it show 'RUN-TIME erro 438'.

When i debug it, it was pointed to this the code below.

I'm suspecting is because of the '" & .cmb_Hname.Column(4) & "' in my body message. But i would need '" & .cmb_Hname.Column(4) & "' to display in the body message and send out. How can I concatenate the whole line and send out? any advise please?

          
...
...
..

.Body = "Message Classification: Restricted" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & "Your security answer is '" & .cmb_Hname.Column(4) & "' ." & vbNewLine & vbNewLine & "Waste Management Database Administrator"
'.Display
.Send

 End With
...
.........