[AccessD] Outlook looking into Access

[Gustav Brock]

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] På 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