Add file to mail from excel

[Sipers]

I've made an Excel file that automatically adds the first two sheets to a email. But I also want that Excel adds the last added file from a particular map. Is that possible?

In the link below you will find my Excel file. When you push the button "Mail verzenden" outlook will open an new email.


WeTransfer: we.tl/WmyEYGo5yV

Please Login or Register  to view this content.

[6StringJazzer]

To add more attachments you can repeat this line found near the bottom of your code.

Please Login or Register  to view this content.

where filepath is the full path name of the file you want to attach. But I can't provide the actual code because there is no context for what files are added (or added to what) or what a map is.

[Sipers]

To add more attachments you can repeat this line found near the bottom of your code.

Please Login or Register  to view this content.

where filepath is the full path name of the file you want to attach. But I can't provide the actual code because there is no context for what files are added (or added to what) or what a map is.

Lets say the map is: \\abw-fs01\home$\Jantje\Documents\My Pictures

How do I convert this is my code?