I have a very simple Address Book consisting of specific Groups and Contacts (i.e. "Programmers" w/200 contacts, "Help Desk" w/500 contacts, etc). It's nothing more than a contact's full name and their email address.
What I'd like to do is, have all groups export into a file that's in an "importable" format for MS Access (v2002 sp3). Ideally, each group will be it's own table and the contacts it's table contents by column. The aim here is this; if I have a job opening for Programmers, I'd like to send an email of a job description to the contacts in the Programmers group alone.
This is how I'm currently doing it in Express but I want to permantly move all my Contact Groups with their respective contacts neatly into it's own table (Programmers = tbl_Programmers) and do away with Express all together.
I don't know if eamiling to a list of addresses is straight forward in Access, hopefully, but adding some code may be required.....I got this from a book.....
Dim appExpress As New MSimn.Application
.
.
Set appExpress = CreateObject ("MSimn.Application") ...etc...
The export I tried so far was going to File/Export the menu choosing Address Book (WAB) and was unable to use this to import this into Access. Another oprion I tried was "Other Address Book" then selecting a "Text File (CSV)". This seemed promising in that it exported the address book in an ASCII format but the problem was, it didn't include the groups just ALL the contacts (name, email add). I need the group and its contacts to export neatly group by group so I can make an an access table out of each.
I'm open to using a third party utility to help in the export/importing everything over to Access 'cause once complete, I will no longer be using Express.
If there's any other informatin I can provide please let me know. Thanks.
Thanks!
Start Free Trial