Mark H
Lists at theopg.com
Wed Jun 18 10:17:48 CDT 2003
I don't know enough to help. Just tried it on this machine... Created
the cert, went into VBA editor and clicked "tools" then "digital
signature" then "choose" under "sign as" and the cert was there. This is
only for self certification I believe so it (possibly???) won't work on
other computers.
Hth
mark
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: 18 June 2003 16:08
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Outlook / Access Email Security
(wasOT:Programmingin Outlook)
I just found and ran it. The cert doesn't show up in the trusted list
however. I also have a real cert (some of you may remember THAT fiasco
a few months ago) and it doesn't show up in the trusted list either.
John W. Colby
www.colbyconsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark H
Sent: Wednesday, June 18, 2003 10:25 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Outlook / Access Email Security (was
OT:Programmingin Outlook)
Look for a file called selfcert.exe it should be in your office
directory
mark
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: 18 June 2003 15:14
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
_______________________________________________
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