Inexperienced
New Member
- Joined
- Mar 14, 2023
- Messages
- 2
- Office Version
- 2013
Hi all,
NEW to VBA and attempting to create a module to save and send a PDF to a LIST of recipients.
This list is on Sheet 2 and does not vary. (Not dependent on information in reports)
Range is A2-A25 Sheet 2.
I can only seem to find Modules with one recipient - or variables.
Any support is appreciated!
- Current Code -
'Attach the PDF file to the email
With OutMail
.To = "recipient@email.com"
.Subject = "Subject Line"
.Body = "Email Body"
.Attachments.Add Filepath & Filename
.Send
End With
NEW to VBA and attempting to create a module to save and send a PDF to a LIST of recipients.
This list is on Sheet 2 and does not vary. (Not dependent on information in reports)
Range is A2-A25 Sheet 2.
I can only seem to find Modules with one recipient - or variables.
Any support is appreciated!
- Current Code -
'Attach the PDF file to the email
With OutMail
.To = "recipient@email.com"
.Subject = "Subject Line"
.Body = "Email Body"
.Attachments.Add Filepath & Filename
.Send
End With