ChloeSpurge
New Member
- Joined
- May 5, 2021
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have this code that creates emails for each row in my table (a different customer) then adds a file, subject etc. However, it only works when the customer has one file, and some emails need up to 10 or more files attaching. I've put the file names in column B separated by commas, anyway to get the code to run through and add all the files?
Thanks for any help
Chloe
I have this code that creates emails for each row in my table (a different customer) then adds a file, subject etc. However, it only works when the customer has one file, and some emails need up to 10 or more files attaching. I've put the file names in column B separated by commas, anyway to get the code to run through and add all the files?
Thanks for any help
Chloe