[AccessD] Outlook / Access Email Security (was OT: Programmingin Outlook)

Dear Dan,

No, this will NOT work.

Certificates will let you use VBA routines inside Outlook without having
to set your security level down.  However, it wont get rid of the "A
program is trying to access your address list" pain.

There is (currently) NO way around this unless you are using Enterprise
Server or you use a different mailing system inside Access (eg Fathmail)
or you go the Redemption route.

Further the outlook is for continued bad weather as M$ does not wish to
admit it is wrong and has stated that it will continue with the
stupidity of the Outlook (so called) security model into the future.

Hope this saves you some time
Bruce


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Thursday, June 19, 2003 12:14 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Outlook / Access Email Security (was OT:
Programmingin Outlook)


I just looked at the Security dialog box in Outlook for the first time,
and read the Help info that went along with it.  (Outlook XP)

The Help info says this:

	A warning is displayed whenever a VBA project from a source that
is
 	not on your list of trusted sources is loaded. [under Medium
setting]

And this:

	This tab [Trusted Sources] lists the currently trusted
certificates
	that can be used by
	developers to sign documents and add-ins. When you open a
digitally
	signed document, the digital signature appears on your computer
as a
	certificate. The certificate names the VBA project's source,
plus
	additional information about the identity and integrity of that
	source. 

This sounds as though I could create a digital signature for a specific
Access application, which, when combined with a security setting of
Medium or High in Outlook, would prevent the annoying 'are you sure'
message box that displays when Access is trying to send a non-displayed
message through Outlook.  If so, that would be wonderful!

Does anyone know how to go about creating such a digital signature for
an Access application?

Thanks,
Dan Waters



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark H
Sent: Wednesday, June 18, 2003 7:34 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] OT: Programming in Outlook


You may need to set the macro security to medium (TOOLS - MACRO -
SECURITY)...

I'm using Outlook 2002 btw - tried what you did and it worked fine on
medium (got prompt to enable macros though)

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: 18 June 2003 14:19
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] OT: Programming in Outlook


Well, I found ThisOutlookSession.  In it I created:

Private Sub Application_Startup()
    MsgBox "startup test "
End Sub

I closed Outlook, and re-opened.  I do not see a message "startup test"

What am I doing wrong?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Wednesday, June 18, 2003 8:43 AM
To: John Colby; accessd at databaseadvisors.com
Subject: Re: [AccessD] OT: Programming in Outlook


On 18 Jun 2003 at 8:24, John Colby wrote:

> Does anyone out there know how to set up an "autoexec macro" (as we 
> know
it
> in Access) that executes automatically when outlook opens?  I am 
> trying to do a little simple stuff in Outlook and don't even know how 
> to do the basics.  Rename modules / classes, get my program to start 
> up and operate when Outlook opens etc.
>

ThisOutlookSession - Private Sub Application_Startup()




--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com