array in a message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use array in a message. Actually, it's a message through e-mail
but it should be the same as a msgbox.
.....
' Creating the array of sheet names
While Str_strSheetname(intI) <> ""
strSheetname(intI) = Str_strSheetname(intI)
intI = intI + 1
Wend
....
strbody = "Hello," & vbNewLine & vbNewLine & _
"Some changes have been done in the following sheets: " &
vbNewLine & _ strSheetname(0) ' ?????????????????? In this way I can send
the one sheet name but how to send them all in the
message?????????????????????????
....
With OutMail
....
.Body = strbody
....

Thanks
 
' Creating the array of sheet names
strbody = "Hello," & vbNewLine & vbNewLine & _
"Some changes have been done in the following sheets: " & _
vbNewLine
While Str_strSheetname(intI) <> ""
strSheetname(intI) = Str_strSheetname(intI)
strbody = strbody & strSheetname(intl) & vbNewLine
intI = intI + 1
Wend
 
Back
Top