Discussion Locked

Automate Contacts into Access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I automate my Contacts into an Access DB or Excel?

2 replies

by joseph moore

If you mean how do you export Contacts from Outlook and get them into Access, I would just Export them.
While you are on the Contacts in Outlook, click File -> Import & Export.
Choose Export to a file.
In the file path box that comes up, create a.XLS file and put it on your system. Then select that the Contacts are exported.
Click Finish to run the export wizard.
that will then export your contacts to the XLS spreadsheet file you specified.

You can then Import this file into Access, orjust open it in Excel.

hope this helps

by pepwin7

That will automate outlook to send the new entry to exl or access -everytime- someone puts in a new contact? That seems so simple, I must have had "Brain Lock"!

This discussion is closed to new replies.