[AccessD] Outlook looking into Access

[Rocky Smolin]

Good. My perfect excuse not to do this.

R
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Mark Simms
Sent: Thursday, May 07, 2015 4:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Outlook looking into Access

VBA coding in Outlook is extremely tricky and challenging.
Period.
Been there, done that.

> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Jim Dettman
> Sent: Wednesday, May 06, 2015 12:43 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Outlook looking into Access
>
>
> Only problem there is you need to be careful where you put code.
> Outlook
> has a "Microsoft Office Outlook Object" section with a module called 
> "ThisOutlookSession" and a "Modules" section where you can add new 
> modules.
>
>  Code that needs to react to Outlook events goes in the first.  Code 
> that does not (such as adding a button to a tool bar) goes in the 
> second.
>
>  On the first, note that the object dropdown has "Application" listed.
> On
> the procedure drop down, these are the events you can react to and add 
> code for. Anything outside of that is ignored by Outlook.
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Gustav Brock
> Sent: Wednesday, May 06, 2015 11:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Outlook looking into Access
>
> Hi Rocky
>
> Pressing Alt+F11 in Outlook, it seems like nothing more than adding a 
> reference to DAO and pull the table. Problem is: What next?
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] Pe vegne af 
> Rocky Smolin
> Sendt: 6. maj 2015 17:16
> Til: 'Access Developers discussion and problem solving'
> Emne: Re: [AccessD] Outlook looking into Access
>
> That code I have.  Going the other way is more problematic.  I 
> suppose, although I've never done it, there's a way to put some VBA 
> behind Outlook like you can with Excel to open an Access table and 
> extract selected email addresses.  But I've never done that.
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of John R Bartow
> Sent: Tuesday, May 05, 2015 5:47 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Outlook looking into Access
> Importance: High
>
> Probably. I went the other way and used Access to email to the 
> addresses in its database via Outlook.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Rocky Smolin
> Sent: Tuesday, May 05, 2015 2:32 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Outlook looking into Access
>
> Dear List:
>
> I developed an app for a client that has a lot of customer contact 
> records with email addresses.  He wants to know if Outlook can 'see' 
> those addresses to create emails - without importing them into the 
> Outlook Contacts folder.
>
>
> I said I didn't know of a way but would ask around.
>
> Can this be done?
>
> I've already told him about the two step process - export from Access 
> db to csv file and import using the wiz.
>
> MTIA
>
> Rocky
>
> --
> 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