Share via

Alternative to ClickYes

Anonymous
2010-08-20T13:49:53+00:00

I have read about an alternative to the program clickYes but can't remember its name.  It is similar to the program redemption but supposededly more reliable and easier ti implement.

Does anyone know about this mystery Program?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-09-05T23:05:20+00:00

    ISSUE RESOLVED  SLICK PRODUCT

    As noted in previous posts the first 3 emails of any size batch would be sent immediately and the remaining 6-296 would stack up in the outbox with s strange icon in front of them.  This happened when using ClickYes or vbMAPI Outlook Security Evader implemented using their sample code.

    Over the next few hours 3 or 6 or some multiple of 3 would be sent.  Most never left the Outbox.  Only happened on 1 PC running MS office 2007: the other 2 PCs are using Office 2000 and emails never stacked up in the outbox.  The SAME Access database was tried on all 3 PCs.

    I made a slight change (moved the Send/Receive command line) to the sample code provided by technical support athttp://www.everythingaccess.com and now everything works great.  Also removed ClickYes as a precaution.

    Just ran another test sending 300 short emails with no attachments and they all cleared the outbox in approximately 4 minutes.  During this time cpu usage was bouncing between 40% and 80% but I was able to open an excel spreadsheet and a work document during this time.

    Below are  part of the code sent to me by everythingaccess, and my slight change 

    The code provided byhttp://www.everythingaccess.com ended as:

             Item.Send

             Set Item = Nothing

             recEmail.MoveNext

        Loop

        Set db = Nothing

        Session.OutlookSendReceiveAll

        Set Folder = Nothing

        Set Session = Nothing

    My code ends as:

                                    Item.Send

                                     Session.OutlookSendReceiveAll       ç New location

                                    Set Item = Nothing

                                    recEmail.MoveNext

                     Loop

                    Set db = Nothing

                    '  Session.OutlookSendReceiveAll      ç Moved this line up

                     Set Folder = Nothing

                     Set Session = Nothing

    Steve

    7 people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-12-07T22:21:12+00:00

    I was using Redemption for a number of years.  One of the drawbacks of using Redemption with VBA and VB6 is the extra coding that you have to do in order to get the email to work without the annoying Security Pop-Up. After ClickYes Pro is installed onto my system, am now able to use this code without dealing with the  Security Pop-Up :

    Dim OutMail As Object

            Dim OutApp As Object

    Set OutApp = CreateObject("Outlook.Application")

           Set OutMail = OutApp.CreateItem(0)

          On Error Resume Next

          With OutMail

             .To = "Whoever"

              .Subject = "Subject goes here

           .Body = " Email Body "

                 ' .Display   'or use .Send

              .Send

         End With

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-08-29T23:01:23+00:00

    I have no experience with Redemption and I think the only thing I have read about it in on a competitors web site.  they would claim to be better wouldn't they?  The program I was thinking of is called vbMAPI Outlook Security Evader.

    I have downloaded vbMAPI and am having problems with it .  It work just great except Outlook 2007 seem to limit the number of emails I can sent at one time to 3: the remaining 10+ stack up in the outbox with a strange icon in front of them. Looks like an envelope with a clock superimposed on it.

    I thought this may be because I was using an academic version of Office that produced the 'non-commercial use' banner on every application.  I recreated the OS partition and reloaded XP (to clear out any registery glitches) and all apps (including Office 2003) with a known good version and installed an upgrade version of office 2007.  Still have the same problem of emails being limited to 3. but the 'non-commercial use' banner is gone.

    Same code on another PC running XP and Office 2000 works fine.  Can send 20-30 emails at a time using the same VBA code. 

    Time to take a look at Redemption??

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2010-08-20T14:28:04+00:00

    I love Outlook Redemption! http://www.dimastr.com/redemption/ I've been using it for years. The code is very similar to Outlook Automation code. In fact, I've written routines that use Redemption and if they error out due to not having the DLL registered my code switches to Outlook Automation.

    1 person found this answer helpful.
    0 comments
  4. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2010-08-20T14:13:32+00:00

    Redemption is rock-solid. Do you have specific information that it is not?

    -Tom. Microsoft Access MVP

    1 person found this answer helpful.
    0 comments