send meeting requests via SQL?

Question

send meeting requests via SQL?

Cory E.

SSCertifiable

Points: 7076
More actions
May 24, 2007 at 7:40 am

#173810

Good day,
I have a DB that has contains our change management system. The majority of the changes are done by members of my group, and sometimes, we forget. I was looking for a way to send a meeting request (exchange / outlook) to users. I have all the data I need in the DB, but I cannot find any sort of way to send an email formatted to be sent to the user for acceptance of the meeting request with reminder.
Does this make any sense?
TIA
Cory
-- Cory

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

I would use Database Mail to send emails, or if you say you have Exchange, you may use SQL Mail. You may use email procedures run upon some events that you define either as triggers or alerts or jobs.

As for the format of the meeting request, you probably need to read Outlook/Excange documentation

Regards,Yelena Varsha

Anders Pedersen SSChampion Points: 11410 More actions · Answer 2

http://www.sqlservercentral.com/columnists/SBoriotti/2985.asp

Might be something in there for you.

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 3

If your using MSSQL 2005 - use database mail; sp_send_dbmail (msdn2.microsoft.com/en-us/library/ms190307.aspx).

Tommy

Follow @sqlscribe

Cory E. SSCertifiable Points: 7076 More actions · Answer 4

I am using 2005, and have looked at sp_send_dbmail, however, that just sends mail. I am wanting to send meeting requests. I have looked at all suggestions thus far, and I am thinking I cannot do this with out going to VB to do this, and that is outside of my scope. thanks!

-- Cory