Solved

How to see if Outlook restricts email from Office VBA

Posted on 2002-04-15
10
177 Views
Last Modified: 2010-04-08
I have an XL macro (VBA) that sends emails using Outlook. Is there a way I can detect if Outlook is setup to not allow emails to be sent via code?

I would like to install Redemption for Outlook on any client's PC that is setup to restrict emails in this way, and those PCs that aren't- don't bother loading Redemption.

How can I tell?
0
Comment
Question by:Thief_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 23

Expert Comment

by:slink9
ID: 6941644
Which version of Outlook?  If OL2000, do you have SR2 installed?  If not, it shouldn't be set up that way.
0
 

Author Comment

by:Thief_
ID: 6941714
Slink9,

That's the whole problem. My code is to be installed on PCs that may have Outlook97, 98, 2000 or 2002.

I need to programmatically determine if the installation of Outlook on the destination PC is inhibiting the programmatical sending of emails from XL VBA.

There must be a registry function that determines if Outlook is "patched" or not!?

Regards.
0
 
LVL 23

Expert Comment

by:slink9
ID: 6941725
Good luck on this one.  Maybe Shekerra or rjcpjc will have an answer.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Expert Comment

by:Neo_mvps
ID: 6942168
slink9: i can't believe you forgot about me. <sniff>

Thief: You would want to check the version property exposed by the application or outlook item objects.

0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6942544
Thief: Just a query.  I'm assuming that you are going to use two snippets of code to send your emails.  One if you have to use Redemption and one if you don't.  Correct?  

And Neo: No one could ever forget about you. <g>
0
 

Author Comment

by:Thief_
ID: 6942614
rjcpjc,

Yes. I will have to incorporate the two different coding formats for sending emails.

Neo mvps,

Can you supply more details about your possible solution? A code snippet would be aprec8ted.

Regards guys.
0
 
LVL 23

Expert Comment

by:slink9
ID: 6942726
Yep.  Sorry.
... and neo may be able to help you with this one, also.
0
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 6945914
For Outlook 2000/2002, it would be a matter of.

Set objOutlook = CreateObject("Outlook.Application")
debug.print objOutlook.Version

for Outlook 97/98, you have to create a mailitem, save it and then read the MailItem.OutlookInternalVersion property.  However this might not be detailed enough to work with.  If it isn't, the only other methodolgy i can think of is to do the following.

1) Read the registry to find out where Outlook is installed.

2) Use the Win32API to read the version information out of outllib.dll
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7242174
Hello Thief_

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ and no refund
-this will be finalized by an EE Moderator
-with no further update (01.09.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7267777
Question has been moved to PAQ as per recommendation

JGould-EE Moderator
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question