

If you need assistance in performing the above steps, please call the Help Desk at x5418.With Contacts Journal, you can directly import your contacts list from a CSV (comma-seperated values) file. If you ever need to add or remove individual addresses, simply double click to open the list, and delete addresses, or go to the end and add new addresses to the list. With your completed list, you can now send messages to this group of people any time you want. Click and drag the entire list of addresses into the list icon in the left hand windowpane.Use the shortcut keys Ctrl-A (PC) or Apple-A (Mac) to select and highlight all the addresses that you imported.Click on that and you will see the list of addresses displayed in the right hand windowpane. In the left hand windowpane, you should also see a new "Address Book" icon with the same name as the file you imported.Follow Steps 1-5 in the "Current Addresses Method" section above.Check the box beside "Primary E-mail" and Click OK. Make sure the first e-mail address in the list is lined up with "Primary E-mail" in the first column.In the next window, locate the file (Mac) or change "Files of type" to Comma Separated to locate the file (PC) and Click "Open".Select Tools -> Import from the menu and click Next on the first window to accept importing an Address Book.Go to: File -> Save As and in addition to naming the list and deciding which folder to save it in, change the "Save as type" to CSV (comma-delimited). Save the file as a CSV (comma-separated values) file.Click and drag to move the addresses from columns B, C, D and onward all into a single column A list. Now the addresses really are in different columns.In Step 3, highlight each column, and check "Text" in the "Column data format" section.In Step 2, uncheck "Tabs" and check "Comma".Click "Next" to accept the default of "Delimited". Highlight the cells in column A that contain addresses.

In Excel, though it may look like the addresses appear in different columns, they are actually all in column A.

If the list is already all in one column, with only one address per cell, then skip to Step 6. The steps below will help you get them all separated and each address on its own line in Column A. The list may export with several lines of addresses, and several addresses per line, each separated by a comma. Go to: File -> Save As and in addition to naming the list and deciding which folder to save it in, change the "Format" to "Text Only" (Mac). Save the list of addresses as a text file.(This is a very handy trick for many situations.) Place your cursor in each of the next blank rows and this time, use the shortcut keys Apple-Y to repeat the delete row function. Place cursor in the first blank row and go to Table -> Delete -> Rows. If you do get a table with empty rows, delete those.Word will automatically change the number of rows to the number of addresses you have, and possibly a few more if you have commas at the ends of lines. Highlight the entire list, and go to Table -> Convert -> Convert Text to Table.If you get a list in "comma-delimited" format (each address separated by a comma), such as class lists from TheHub, copy and paste the list into Word (Mac) or Excel (PC). It will be a little tricky at first, especially if you aren't used to using tables in Word, but after a couple of times, you will be able to fly through the steps. You do that by opening and saving the list in Word, then importing the list to Thunderbird. However, you must first get the list into Thunderbird. If you get a new list of e-mail addresses that don't already exist in your Address Book, you can still create a list using the method above. Double click on the List icon to open it and verify that all the addresses have been added.Click and drag them into the List icon in the left hand windowpane.When you have hightlighted all the addresses in this way, Ctrl-Click (PC) or Apple-Click (Mac) on each additional address. With Personal Address Book highlighted (or Collected Addresses if you have more addresses here), locate the addresses you want to add to your list.In the left hand windowpane, click on the + beside "Personal Address Book" if that is where you saved the list.Fill in "List Name", "List Nickname" (an easily remembered abbreviation so you type less), and "Description" (optional).In this tip, we'll cover that simple process, as well as what to do if many of the e-mail addresses are not already in your Address Book.

Creating a mailing list from your current Address Book can be as simple as dragging the addresses into a list.
