Is there any way to be able to access a spreadsheet based distribution list from outlook without having to create and then edit (as changes are made in the original spreadsheet) a static contact list in outlook?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Email distribution list
- Thread starter ajm
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,699
- Office Version
- 365
- Platform
- Windows
- Mobile
What do you mean by "access"? It would not show up, for example, if you click the To button in an email to get a contact list.
The strategy would be to keep the list in an Excel file, and have a macro in Outlook that opens the Excel file and reads the names to compose an email to that list. You would either run the macro from Outlook or set up a button to run the macro. Alternatively you could use an Excel macro to send the email. How much detail do you need?
The strategy would be to keep the list in an Excel file, and have a macro in Outlook that opens the Excel file and reads the names to compose an email to that list. You would either run the macro from Outlook or set up a button to run the macro. Alternatively you could use an Excel macro to send the email. How much detail do you need?
Upvote
0
Similar threads
- Solved
- Question
- Solved
