There are several ways, but by far the easiest was suggested by a colleague, Stephanie M. Bryant, CPA, Ph.D., a professor of accounting at the University of South Florida, Tampa. Format the list so it’s in a single column in the spreadsheet. Highlight the column and press Ctrl+C to copy it. Then open a new worksheet and select Edit , Paste Special and check the Transpose box at the bottom of the screen to transpose them from a column into a row. If the cell width is so narrow you can’t see all the addresses, select Format , Column , AutoFit . Now you’ll need a semicolon separator between each e-mail address. To do this, highlight the row and press Ctrl+F to do a Find and Replace . Find all the address endings (such as com) and add a semicolon (com;) as a replacement. Finally, copy (Ctrl+C) all the addresses, open your e-mail application, and paste them in the block after To … | ||