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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-10-01 : 05:51:33
|
| hello,I send bulk mails thro' sql procedure,the mails contains the profiles of the users.currently I use cdonts.new mail to send the mails.now if the mail goes above 4000 it gets truncated.is there any other way of sending mails in html format.And now I have to send photos in the mails .are there any other ways of sending mails through stored proceudres??like aspmail etc..u'r advice is appriceated,harshalEdited by - harshal_in on 10/01/2002 06:23:00 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-01 : 06:59:27
|
| My advice would be "Don't send HTML email" and "Send photos as attachments", but I imagine that's not the answer you're looking for.If you can use ASP then go with that, there's some decent 3rd party components that are pretty cheap. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-01 : 08:17:34
|
| can anyone suggest other components for sending mails whith sql server 2000 . |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-03 : 02:34:31
|
| ya I read it just now and had a discussion with my senior he said it will work but here I am going to face the limitation of 8000 characters ,have u completed the article which u have mentioned here about overcoming the limitation of 8000 characters??secondly is there any way of excessing text data in the stored procedure since we can not declare a text datatype in a procedure??is there any thing like pointers which can directly point the required start of the page containng the required data??tnxs for the help harsh. |
|
|
|
jansen
Starting Member
5 Posts |
Posted - 2002-10-03 : 03:30:16
|
| The only way I have found to work is to write a COM wrapper for cdonts and then use sp_OA.. to work with it./Jansen |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-03 : 08:15:30
|
| can we use the txtptr() in the message field of the mail while using aspmail???,if yes how?please help.harsh |
|
|
|
|
|
|
sending mails help needed!!!!