Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to see if Outlook restricts email from Office VBA

Posted on 2002-04-15
10
Medium Priority
?
181 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_
  • 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article lists the top 5 trialware OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their Exchange server is no longer available or other critical issues with Exchange server or impo…
Mailbox Overload?
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

972 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