Solved

How to see if Outlook restricts email from Office VBA

Posted on 2002-04-15
10
172 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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: …

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now