Solved

How to see if Outlook restricts email from Office VBA

Posted on 2002-04-15
10
176 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Find out what you should include to make the best professional email signature for your organization.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

696 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