Bypassing Security Issue When Sending an email from MS Access 2013 Macro using Outlook 2013 on a 64bit machine

I previously used the clickyes pro solution to enable me to use a macro in MS Access 2013 to programmatically email a report using Outlook 2013. However, I've recently been migrated to a 64bit machine with 64bit versions of Windows 7 and Office 2013. In this new environment, clickyes pro does not work. I contacted them and they said that they don't have a version that will work in a 64bit environment.

Is there another solution similar to clickyes pro that will work in a 64bit environment?
LVL 1
edsleeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kelvin SparksCommented:
The only product that I know of that integrates with Outlook is one called Redemption (http://www.dimastr.com/redemption/home.htm). Have been using it with Outlook from 2007 onward on 64 bit PCs


Kelvin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
edsleeAuthor Commented:
Thanks Kelvin,

Is Outlook Redemption something that I download and it starts to work? ...or do I need to write code to use this? The technical level of the webpage is beyond what I can understand. Thoughts?

Ed.
0
Kelvin SparksCommented:
You download it, install it,  then add some code (they give examples) and it works.

Kelvin
0
The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
There is redemption and also VB mapi from www.everythingaccess.com.   Check with them  though to make sure they have a 64-bit version. Not much out there for 64-bit and I would avoid it if possible. No significant advantages to using it either outside of very large spreadsheets in Excel.

Jim
0
McKnifeCommented:
Right.
Unless you need it, always use 32 bit office https://technet.microsoft.com/en-us/library/ee681792.aspx Microsoft recommends so because of plugin/add-on/etc. compatibility. Windows x64 has no problems with office 32.
0
Dale FyeCommented:
I use vbMapi for one of my clients that is running the 64bit version of Office 2010.  I assume it will work with 2013 as well.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also, if just sending e-mail, you don't have to use outlook.   There are other methods.

Jim
0
edsleeAuthor Commented:
Thanks everyone for your comments and guidance. I am exploring the redemption and EverythingAccess options. It is unfortunate that VBA is over my head. Progress is slow. I'm open to other suggestions?

Ed.
0
McKnifeCommented:
You should have commented on whether you really need the 64-bit office version.
0
Dale FyeCommented:
"VBA is over my head"

Maybe now, but not forever.  Just keep plugging at it and coming back here with questions.  Then take the time to understand the answers and you will learn.  That's how most of us did it.
0
edsleeAuthor Commented:
My datasets are huge. The 64bit environment has significantly cut down the time needed for my computer to render the reports (MS Access as well as MS Excel). My computer also has not crashed since switching to 64bit.  I just can't get the reports sent out like I could before.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.