Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
80
Views
Topic starter
Hi, following the dynamic mail function with options for "TO", "CC", "SUBJECT", "BODY"
is there an option to attach file automatically? the name and path of the file will taken from additional column.
thanks
Posted : 14/10/2022 5:36 am
Hi Susy,
You can use .Attachments.Add Range("A1") where A1 contains the full path to the file.
This post explains in further detail
Create PDF from Excel and Email with Outlook
Regards
Phil
Posted : 17/10/2022 6:33 pm