[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Format email from SQL server the same way gmail formats vcalendar emails

Posted on 2008-02-08
3
Medium Priority
?
935 Views
Last Modified: 2010-04-21
Just wondering if anyone knows how to do this in SQL.

I can send emails with .ics attachments via CDO.message, but they come with without any buttons, the user has to open the attachment to create the appointment.  

Also, is there  a way to format the email in such a way that you do not need to include the file as an attachment.. just sent a direct email from sql.

Thanks
0
Comment
Question by:Brent
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 1500 total points
ID: 20855633
Check sp_send_dbmail procedure in BOL...
You can use HTML format or other check the examples....
http://msdn2.microsoft.com/en-us/library/ms190307.aspx
0
 
LVL 8

Author Comment

by:Brent
ID: 20868095
I realize i posted this in both the 2000 and 2005 forums... but

That appears to be a SQL 2005 only proc.  Are their any for 2000 or can i port that one( i assume not )?

Thanks!
0
 
LVL 8

Author Closing Comment

by:Brent
ID: 31429363
I needed 2000, but you provided an answer for 2005.  Since i didnt state it in my original question and you did provide a solution, i am awarding the points for effort and possible solution if i upgrade.

Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question