Forum Discussion
copy address book
I need to copy all the email addresses in my "Outlook Address Book" into an Exce; spreadsheet.
I can "open" my address book in Outlook and see all the entries.
I can high-light them all.
But Ctrl-C refuses to "copy" them.
Or is it Ctrl-V in Excel that refuses to paste them ?
Outlook does "seem to" have an "Export" routine, but that only pastes the first fifty and the last item !
VERY strange . . .
1 Reply
Hi RobinBClay,
The Outlook Address Book does not support direct copy functionality.
If the email addresses are stored in your Contacts list, you can export them as a CSV file using Outlook’s export feature.
However, if you're trying to copy addresses from the Global Address List (GAL), you'll need to work with your IT administrators. If you have the necessary permissions, you can also use PowerShell to export the global list.
--------------------------------------------------------------------
If this response was helpful, please consider giving it a like and marking it as the accepted answer.
Your feedback helps others and supports the community!
