View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default vba code runs...need spaces ........

Hello
..Subject = "Credit-Notice " & Range("R14").Value & Range("AR35 ").Value &
Range("AC11").Value & Range("S10 ").Value

The above code is in my subject line in the "Sub Mail_ Active sheet ()"
When the macro runs everything in the subject line of the e mail is one
sentence
example Credit-Notice1234567WaterWorks100.00
I want the subject line to read Credit-Notice, Invoice No 12, Acct No 34567,
Company Water Works , Amount 10.00
Thanks in advance