Database Mail

External Article

Send email in a tabular format using SQL Server database mail

  • Article

Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.

2011-04-12

5,799 reads

Blogs

Lift and shift vs modernizing your data warehouse

By

If you are migrating a data warehouse, there is a question worth asking before...

Power BI Fun With Travels

By

I’m back from a great vacation. I had the chance to visit two new...

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

Read the latest Blogs

Forums

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

PostgreSQL psql Meta Commands: Tables

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server

By john.martin

Comments posted to this topic are about the item Building a Support Ticket Triage...

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers