Hi sungen99,
Per my example attached- I would like to have an excel document that will list all of our clients and prospects. Sorting out when someone who is a prospect gets cut off and all the other logistics, I can handle just fine. You will see an Update List button.
What I would LOVE to have this do…… is take the group lists and update the associated distribution lists in Outlook.
You created an interesting Challenge. First I had to build the tools to add/delete Contacts, Add/Delete Groups and Add/Delete Contacts from Groups. See the attached modified copy of your file as a starting point. Please let me know if you need any changes.
I propose the following which is similar to what you requested. All Activity is from Excel (Outlook must be open).
a. You modify the file and test to make sure Contacts and Groups are correct.
b. You make a copy of the file and send the copy as an Email Attachment to your users.
c. The users Download the file, and run 'Update Lists'.
d. Update Lists automatically sends an email to you (with a cc to the User) showing the status of what was done.
e. The return emails will help you verify when a User has the current list.
For the Benefit of others here are a few non-working code excerpts. Full working code is in the attached file.
To add an Outlook Contact:
To delete an Outlook Contact (Contacts may still exist inside Groups after a Contact is deleted):
To add a Group:
To delete a Group (does not Delete Contacts):
To add a Contact to an Existing Group:
To Delete a Member from a Group:
To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.
To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.
Lewis
Bookmarks