Download message attachments to local disk
Downloads message attachments to a folder. Use download_message_attachments with WITH(Search='...', SaveFolder='...', OverwriteFile='...'). Files are saved as {SaveFolder}\{message_id}_{attachment_filename}.
SELECT *
FROM download_message_attachments
WITH(
Search='subject:(daily report for July-2024)',
SaveFolder='c:\temp',
OverwriteFile='True'
)