Help with combining strings
Please I need immediate help to understand this. I store values in rmarkfor,
qtenum,dlrname -- I would like the subject line of the email to read like
this:
To: Iccquote
Subject Quote # (the value of qtenum), (value of dlrname), (value of rmarkfor)
But it keeps giving me a compile error.
Set rmarkfor = Range("C5")
Set qtenum = Range("F5")
Set dlrname = Range("C7")
Set alltext = "Qte #:" & qtenum & "-" & dlrname & rmarkfor
With ExlPpsl
.SendMail "Iccquote", _
& alltext
End With
|