View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rookie_User Rookie_User is offline
external usenet poster
 
Posts: 78
Default 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