Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba code runs...need spaces ........
Hi,
Create a constant of ", " and put it between each element of your string Const gap As String = ", " Subject = "Credit-Notice" & gap & Range("R14").Value _ & gap & Range("AR35 ").Value & gap & Range("AC11").Value & gap & Range("S10 ").Value Mike "Wanna Learn" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba code runs...need spaces ........
..Subject = Join(Array("Credit-Notice", Range("R14").Value, _
Range("AR35").Value, Range("AC11").Value, Range("S10").Value), " ") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Wanna Learn" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
spaces not recognized as spaces | Excel Worksheet Functions | |||
Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
Numeric code of spaces! | Excel Discussion (Misc queries) |