[AccessD] Outlook looking into Access

[John R Bartow]

And the biggest problem for me was - which version of Outlook? The beast is
not consistent enough to allow for a runtime reference. You'd have to verify
that the objection model and VBA you use works with each version you might
expect to run it with. I currently support 2003-2013, that’s a lot of work
if you can do it the other way around. 


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Wednesday, May 06, 2015 10:33 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Outlook looking into Access

How would one then in Outlook, trigger that code which would have to open
some kind of list from the table, allow the user to select names, and push
those email addresses into an email?

TIA

Rocky
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Wednesday, May 06, 2015 8: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] 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 

--
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