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