How to send the last saved file using SMTP?

AlanSmill · March 28, 2019, 12:45pm

Hello guys, im working in a project where i have to send the last saved excel file to a person using the smtp option, how can i do this?

ronanpeter · March 28, 2019, 12:58pm

Analyse the directory of the Excel workbooks for the last saved file

directory.getfiles("YourFolderPath)

you can then get the last write time for each

Select the file which has the most recent write time.

SMTP Activity then has the option to attach the document

AlanSmill · March 28, 2019, 12:59pm

Thank you ill try this one right now!

Topic		Replies	Views
To attach excel document in SMTP Help activities	3	892	February 7, 2020
Last saved file Studio excel , outlook , studio , question , folders , email	7	875	January 18, 2023
Send graphic via email Studio activities , question	2	642	February 27, 2020
Smtp excel attachment failed Help excel , mail , activities , error	7	907	January 20, 2020
Get lastest documents in folder in the past hours Help excel , activities , studio	9	1712	February 10, 2019