John Colby
jcolby at colbyconsulting.com
Wed Jun 18 12:21:18 CDT 2003
Got there. Outlook now takes a very long time to open, and the message never shows. something happened once and the message did display, but not repeatable. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Wednesday, June 18, 2003 12:57 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] OT: Programming in Outlook Alright John, I have never done this, but I am a little surprised you didn't figure this out too. I'll explain what I did. First, I went Tools --> Macro --> Visual Basic editor, and got the VBE for Outlook. I then looked under Project 1, and saw Microsoft Outlook Objects. There was just one object, 'ThisOutlookSession'. I selected that, and got the code page for the ThisOutlookSession 'class'. Once inside, I looked at the objects (top left drop down on your code page), and saw Application. Once that was selected, I looked at the events (top right of the code page), I got ItemSend, NewMail, OptionsPagesAdd, Quit, Reminder, and Startup. Just a guess, but I would say that Startup would do the trick! <grin> Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, June 18, 2003 8:07 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] OT: Programming in Outlook 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 _______________________________________________ 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