Search results
14 sty 2018 · database email with attachement(excel file / pdf file)? Maybe you can use Excel to import the data from SQL Server and then get excel to fire off the email.
One way is to use the extended stored procedure xp_sendmail. It does require that you have a MAPI profile and SQL Mail configured. Then it can be used like this: xp_sendmail @recipients = '[email protected]', @subject = 'Query Results', @query = 'SELECT fname, lname FROM Employees WHERE empid = 9'
28 cze 2022 · You can do that using T-SQL exec msdb..sp_send_dbmail @recipients = '[email protected]', @subject = N'CSV Report', @body = N'PFA', @query='select * from db.dbo.table', @query_attachment_filename = 'YourReport.csv', @attach_query_result_as_file = 1, @query_result_header = 1, @query_result_width = 32767, @append_query_error = 1, @query_result_no ...
9 kwi 2022 · I recently switched to Microsoft 365 Online and don't have full access to the desktop versions of Word and Excel. When I open a Word or Excel file from my desktop it still opens it in the desktop application, but I would like it to automatically open in the online version.
23 lut 2023 · Alternatively, you can implement this functionality with SQL queries using only two actions, Open SQL connection and Execute SQL statements. Open a SQL connection to an Excel file. Before running a SQL query, you have to open a connection with the Excel file you want to access.
19 lip 2023 · Simple steps to send emails from Excel with PDF attachment. Put email addresses in list, choose folder, click macro button for test email, then send to list.
1 lis 2023 · SQL statements in Excel allow you to connect to an external data source, parse fields or table contents, and import data without having to manually enter the data. After importing external data using SQL commands, you may sort, analyze, and conduct any necessary computations.
