In the Convert Text to Columns Wizard – Step 1 of 3, please check the Delimited option and click the Next button.Ĩ. Keep selecting the cell, and click Data > Text to Columns.ħ. Now all contacts of the Global Address List are pasted into the selected cell in Excel.Ħ.
Create a new workbook, right click a blank cell and select Keep Text Only in right-clicking menu. Please select all recipients in the To filed, right click and select Copy from the right-clicking menu. (3) Click the To -> button to add all contacts as email recipients.Ĥ. (2) Select all contacts with holding the Shift key and clicking the first contact and the last one (1) Select the Global Address List from the Address Book drop down list
In the Select Names box, please (see screenshot below): Go to the new Message window, and click the To button in the message header. Create a new email with clicking Home > New Email.Ģ. Please follow below steps to export the Global Address List or an Address Book from Outlook to Excel.ġ.
