CODEWITHSUNDEEP
ms-accessoutlook
Tan Yong Jin Stark
Tan Yong Jin Stark

Reputation: 131

Access to Outlook Intergration

I would like to ask if email address in an MS Access DB can be imported into MS Outlook (preferably in contact groups defined in MS Access)? If so, how can this be done?

Thank you.

Upvotes: 0

Views: 334

Answers (2)

Erik A
Erik A

Reputation: 32642

The preferred way to work with outlook items in Access, is through linked tables. Access can directly link to your outlook files.

Steps (Access 2016):

  • Go to External Data
  • Click New Data Source
  • Click form other sources
  • Choose Outlook folder
  • Choose Link the data source by creating a linked table
  • Choose the address book you want to link
  • Click Finish

You now have a linked outlook address book as a table. You can use normal action queries to insert into and update your address book.

Upvotes: 1

ashleedawg
ashleedawg

Reputation: 21639

To import a CSV of contacts into Outlook,

  • click File then Open & Export
  • click Import/Export and Import from another program or file
  • click Browse and locate your .csv file

You'll have the option to map custom fields -- in case you don't have them stored in a standard way (like this sample).

More:

Upvotes: 0

Related Questions