A Better Idea

BY STANLEY ZAROWIN

A BETTER IDEA
An article in the June column suggested a fast way to create an e-mail distribution list in Outlook from a column of addresses in a spreadsheet. Bryan Caston, an Exchange engineer with AT&T who reads the technology section of his CPA wife’s copy of the JofA, suggests a way to accomplish the task without transposing the Excel list or inserting semicolons between the e-mail addresses

Copy a column of e-mail addresses from your spreadsheet and paste it into Outlook’s To, Cc or Bcc. Although Outlook will automatically format the addresses after a short delay, you can speed the process by changing a default: Go to Tools, Options, Preferences, E-mail Options, Advanced E-mail Options and be sure a check is next to Allow comma as address separator and Automatic name checking (see screenshot below).


 


You also can trigger the action immediately by pressing Ctrl+K, or, in some copies of Outlook before 2007, there is a Check Names function under the Tools menu (see screenshot at left).

 

 


And in Vista you can find a Check Names icon in the Message ribbon.

 

SPONSORED REPORT

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.