Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wwwscottcouk
Starting Member
6 Posts |
 Posted - 2004-10-27 : 05:56:09
|
| Hi all,How would I go about sending an individual an email with information from an sql database database which holds data about a fault that they have logged.So in theory - from my Access front end, I click a button which sends a request to the sql server to send an email to that particular person.Plus to complicate matters - I'am a bit of a novice when it come down to sql scripts. So any help would be very very much appreciated.Kindest RegardsScott |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-27 : 06:02:28
|
| It's amazing how many people ask this question...and that sql-server doesn't have any other option but the friggin MAPI-account-deal. Check this out:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36293--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
wwwscottcouk
Starting Member
6 Posts |
Posted - 2004-10-27 : 06:37:20
|
| Its amazing how many people take a huff when someone who wants to learn more asks a question which has apparently been asked before....sorry - I should have joned 'The Borg' I suppose.Would anyone else like to make my first SQLTeam Forum experince a memorable one ?? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-27 : 06:46:26
|
Oh, I'm sorry!!!  It was not my intention at all to be rude or anything like that...it's just that alot of people have been asking about sending email lately and I don't understand why MS haven't made this easier in sql-server. It's a complete mess to get the included xp_sendmail or other email options to work... My comment was just a general remark and not intended for you personally. The link I gave you should give you some pointers to what I did and it works like a charm with extremely little tweeking.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-27 : 20:42:10
|
| I agree, the need to install MAPI seems reasonable, but installing Outlook on a dedicated SQL box, as a means of getting "enough" MAPI, stinks.Doing a load of COM stuff as a work around seems like a PITA. I mean ... I only want to communicate with an SMTP server ... why should MAPI/Outlook be required by SQL's internal gubbins in order to do that?Kristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-27 : 21:28:04
|
| Seehttp://www.nigelrivett.net/Email.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-27 : 22:51:53
|
| Yeah, but that needs xp_sendmail, which in turn needs Outlook on the SQL box - or is there some way to get SQLMail without installing Outlook?Kristen |
|
|
|
|
|
|
|
|
Emailing from SQL