Solved

How to see if Outlook restricts email from Office VBA

Posted on 2002-04-15
10
178 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Find out what you should include to make the best professional email signature for your organization.
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
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: …

628 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