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 --- _______________________________________________ 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/cajidmykcugbl93jnqt8jq4vab5ybj42jj24wovp_bjkcr5h...@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.
