ODBC guide

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'
	  )