By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,870 Members | 2,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,870 IT Pros & Developers. It's quick & easy.

Outlook Address Book

P: n/a
Can anyone give me sone code to add addresses from a query to an Outlook
Address book. The problem is that I want to add the new email addresses to a
distribution list, not to the main email list

TIA
Phil
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Phil,

Open to the database window and the tables tab. Click on File- Get External
Data. Click on "Link". At the bottom, change to "Outlook". Choose the Outlook
Address Book and press OK. The Outlook address book is now like any other
database table and you can create queries, forms and reports based on it.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.net ...
Can anyone give me sone code to add addresses from a query to an Outlook
Address book. The problem is that I want to add the new email addresses to a
distribution list, not to the main email list

TIA
Phil

Nov 12 '05 #2

P: n/a
Thanks for that. I had no idea you could link with outlook. However although
I can see the distribution list entry, I can't see how the individual
entries for the distribution list are linked back

Eg I have a Distribution List called "Club Members"
Within this list I have Tom To*@xyz.com
Dick Di***@Freeserve.co.uk
Harry Ha***@Smith.co.uk

I want to insert Fred Fr**@somewhere.net into the "Club members" section
of the contacts file

any ideas

Phil

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:mq******************@newsread1.news.atl.earth link.net...
Phil,

Open to the database window and the tables tab. Click on File- Get External Data. Click on "Link". At the bottom, change to "Outlook". Choose the Outlook Address Book and press OK. The Outlook address book is now like any other
database table and you can create queries, forms and reports based on it.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.net ...
Can anyone give me sone code to add addresses from a query to an Outlook
Address book. The problem is that I want to add the new email addresses to a distribution list, not to the main email list

TIA
Phil


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.