Hi,
I am trying to send multiple attachments on an email.
I am using the following code to send a single attachment however I would like to send all the attachments located in Column C on a sheet named "ITEM INQUIRY LIST"
With OutMail
.To = Range("P8").Value
.CC = "Mickey.Mouse@Disney.com"
.Subject = "Encore Glass Samples are on their way to " & Range("R4").Value & " (" & Range("Q6").Value & ")"
.Attachments.Add Range("P30").Value
.Body = EmailBody
.Send
End With
Assistance would be greatly appreciated!
I am trying to send multiple attachments on an email.
I am using the following code to send a single attachment however I would like to send all the attachments located in Column C on a sheet named "ITEM INQUIRY LIST"
With OutMail
.To = Range("P8").Value
.CC = "Mickey.Mouse@Disney.com"
.Subject = "Encore Glass Samples are on their way to " & Range("R4").Value & " (" & Range("Q6").Value & ")"
.Attachments.Add Range("P30").Value
.Body = EmailBody
.Send
End With
Assistance would be greatly appreciated!
Last edited by a moderator: