Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
Combining Text Strings - Complex | Excel Worksheet Functions | |||
Combining text strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming |