Hi all,
I currently have a macro that generates an email from excel. On sheet4 I have a list of recipients in range "B7:B23" and i'm looking to include all recipients in my email however i'm not sure how i adapt the below to do this. I know I can reference each cell however the specified range will increase over time. Is there an alternative to the below method?
The below is what i'm looking to adapt
I currently have a macro that generates an email from excel. On sheet4 I have a list of recipients in range "B7:B23" and i'm looking to include all recipients in my email however i'm not sure how i adapt the below to do this. I know I can reference each cell however the specified range will increase over time. Is there an alternative to the below method?
VBA Code:
.To = Sheet4.Range("B7") & Sheet4.Range("B8").Text
The below is what i'm looking to adapt
VBA Code:
With OutlookMessage
.To = ""
.CC = ""
.BCC = ""
.Subject = TempFileName
.Body = "Please see attached." & vbNewLine & vbNewLine & "Fleet"
.Attachments.Add TempFilePath & TempFileName & FileExtStr
.Display
End With