Reader Benjamin Peacock confronts an issue regarding the intersection of Excel and Mail. He writes: I have an Excel spreadsheet that contains a list of email addresses. Before Mavericks, I could create an email message that used all these addresses simply by copying the cells and pasting them into a message’s To field. With Mavericks’ Mail the necessary comma is missing between each address when I paste them in. Without the commas I can’t send the message because I’m told the addresses aren’t formatted correctly. Is there a way to fix this? Best video viewer for mac. Previous devices are supported by older releases. Please use version 2.0.10 linked below. Note that the first generation of Intel-based Macs equipped with Core Solo or Core Duo processors is no longer supported. Older versions of Mac OS X and VLC media player We provide older releases for users who wish to deploy our software on legacy releases of Mac OS X. Oct 22, 2012 The email addresses are now all in that cell reading across (the LF characters are gone) With the new cell still selected press Ctrl-C or right-click Copy Go to outlook.com and press Ctrl-V. ![]() There is, and it’s all done within Excel. For the sake of our example, let’s say that all your addresses are in Column A, beginning with the A1 cell. Within this very article copy this bit of text— =A1&','—click in the B1 cell, and choose Edit > Paste Special. In the Paste Special window that appears leave Unicode Text selected and click OK. The address in A1 will now appear in B1, but be followed by a comma— [email protected],—for example. Double-click in the bottom-right corner to format the addresses in Column A. Now move your cursor to the bottom right corner of the selected B1 cell until you see a black plus (+) cursor. Double-click on that corner with the cursor showing and all the addresses in Column A will now appear in Column B using the comma-added format. All you have to do now is copy the addresses from Column B into a Mail message. Before we leave, allow me to offer you one more bit of advice. I wouldn’t add all those addresses to the message’s To field. When you do this, everyone who receives the message will see each email address you sent it to. Some people don’t wish to share their addresses with others and so you should respect their privacy. You can do this in Mail by choosing View > Bcc Address Field (Command-Option-B) and pasting those addresses into this field. There’s no need to enter anything into the To field but if you feel better putting something there, insert your own email address. Those people receiving the message won’t see the addresses of others you’ve sent it to. You can use any list of email addresses to create a DL (or Contact Group), including from Excel or a custom view in Outlook (with only the display name and email address visible.) The only requirement is that each member's information needs to be delimited with a semi-colon or paragraph mark (one name and address per line). If there is not a display name, the address will be used for the display name in the finished DL. Poremsky Diane Poremsky;; Create a DL (Contact Group) from a List of Addresses While you can get the addresses from any semi-colon delimited or one address per line list, this page was originally written to help people who wanted to create a DL from addresses in a message they were CC'd on. The instructions to create the DL once you have the list of addresses is below. To get the addresses from the Internet header • Right click on the message.
0 Comments
Leave a Reply. |