[AccessD] OT: Programming in Outlook

John Colby jcolby at colbyconsulting.com
Wed Jun 18 08:07:07 CDT 2003


Stuart,

I'm afraid you're going to have to get more verbose than that.  ;-)

I am a competent VBA programmer, understand object models etc.  However
until this morning I have never looked at programming Outlook from inside
Outlook itself, having always automated it from Access.

So... what is ThisOutlookSession?

When I click Macro/visual basic editor I end up in a new module I created.
Outlook seems to know about the modules I created in the past.

Let's get basic... where are these modules stored?  How are they associated
with Outlook opening, i.e. why do I see them in the editor?  IOW, in Access,
I open an actual outlook "file" (an MDB) and I do so intentionally somehow,
by dbl-clicking it from explorer etc.  So I open a container that holds my
code.  Is there a similar "code container" in a pst file, and because I open
the same pst I get the same module?

I am able to get into the code editor but I can't seem to find any obvious
way to rename a module (for example).  The simplest things are just
different.

Is it possible to create a "library" similar to an mda in Access where I
work on code and "reference" that library from Outlook?  If so, how do I do
that?  What would the file be called?  Where would it be stored?

Coming from Access a lot of these problems didn't exist, or I learned the
answers so long ago that it is all second nature.  NOTHING is second nature
here.

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





More information about the AccessD mailing list