I have SQL Server Express 2008 R2 and as far as I can see, it doesn't support database mail (unless I didn't set it up properly).
The threading model of CDO looks interesting so I'll give it a test and see what happens. Laurie On 14 April 2014 17:20, Stephen Russell <[email protected]> wrote: > On Mon, Apr 14, 2014 at 10:45 AM, Laurie Alvey <[email protected]> > wrote: > > > I have a form which sends an email using CDO. Sending one email is no > > problem, but I want to extend the app's functionality by using a form to > > send bulk emails from a table. Retrieving the email addresses is no > problem > > but I need to know that one email has been sent before I compose the next > > one. > > > > I've looked at the PEMs for the CDO class but can't see anything obvious. > > I've noticed that the screen cursor changes to an hourglass during the > > sending but I can't go into a wait state until it changes back. I thought > > of DOEVENTS FORCE, but I'm not sure if that would help. > > > > Any ideas welcome. > > > > ------------------ > > Not sure but I think that SQL Server Express does Database mail. I worked > in a company and we did all our mailing to everyone via a drop a row into > the mail table and it would send it out. > > Standard columns held all the elements for setting up CDO mail. > > Now you can drop all the rows needed to send at high speed and SQLServer > can slam it out real fast as well running a mail job every 5 min or 15 min > is you want. > > Just giving a new opportunity to just drop data into another system at high > speed. > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/camvtr9cmf-99fjhqr290je-6pqdxe19kh+wskr4s3la708t...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
