Forum

Notifications
Clear all

Mail function with attachments

2 Posts
2 Users
0 Reactions
80 Views
(@susyd)
Posts: 1
New Member
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
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

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
Share: