Importing Email Addresses Into Thunderbird
I am using the current version of Thunderbird on a Windows 10 PC and a MacBook Pro. I want to create an email broadcast list with about 100 email addresses for our Homes Association.
Instead of me manually typing each address into Thunderbird is there a way to import the addresses into Thunderbird from Microsoft Access (database) or Microsoft Excel (spreadsheet)? Thanks! Bill |
Yes, you can do this. Export the data in either LDIF format or CSV format with comma separators. It’s easier if you rearrange the order of the CSV data fields to match the Thunderbird default order and place the CSV field names in the first row. More details here:
https://support.mozilla.org/en-US/questions/1154012 Bill |
n5bb - thanks very much for your post. I will look at the link. I really appreciate the information.
Bill |
I think I may be having trouble correctly importing addresses from Excel into the current version of Thunderbird.
I have a two column Excel spreadsheet with the columns named Last Name and Primary Email. In each of these columns is the person's last name and their email address. I have saved the spreadsheet to a .csv file. I have followed exactly the importing instructions in the link above and a new address book named HOA Mailing List was created. When I double click on the address book the information appears in two columns titled Name and Email. The strange thing is that the information under the Name column is the text that is BEFORE the @ sign in the person's email address. The information under the Email column is the person's complete email address which is correct. When I double click on an entry the Edit Contact box opens with the person's last name in the "Last" box and the person's correct email address is in the Email box. When I double click on the address book and it opens why doesn't the person's last name appear under the Name column as I thought the column would be titled Last Name instead of Name. During the import process I matched the Last Name and Primary Email to the spreadsheet columns. The list has 75 names and I am afraid to send a test message to the members until I know it will work. Any ideas or thoughts are appreciated. Thanks, Bill |
Ah ... that's because of several odd decisions made by the Thunderbird developers. The Thunderbird address book display ignores the "First Name" and "Last Name" fields and instead uses the "Display Name" field as the name in the listing and when creating the To field in a composed email, although the First Name and Last Name are still visible if you inspect the details about a record. If there is no Display Name, Thunderbird assumes the left portion of the email address (before the @) is the display name. This makes no sense to me -- they could have concatenated the First Name and Last Name fields in that case, but they didn't. If all of those fields are present (First Name, Last Name, and Display Name) it works fine, but my guess is that you don't have a Display Name set up in your database.
So in Excel here is how you can concatenate the First Name and Last Name fields:
|
n5bb;
Thanks very much for your detailed message. I was a little confused but I was able to accomplish what I wanted to do. I only wanted to import the person's last name and their email address. In my Excel spreadsheet I made the first column name "Display Name" and the second column name "Email". I did the import and it worked the way I wanted. Thanks again for all the time you gave to help me - I really appreciate it! Sorry for the delayed reply letting you know what I did. I had hip replacement surgery a week ago so I have been off the computer doing all of my exercises and physical therapy - no fun! Bill |
I'm glad you got it working, Bill. My hip joints are OK, but my knees are wearing out. Going downhill (especially down stairs) is no fun. My dad had total knee replacement on both of his knees on one day! That was over 20 years ago, and he passed away from unrelated causes 15 years ago. My mom fell and broke her hip 15 years ago, and I remember her recovery. I'm sure they have better surgical techniques and recovery plans today. Hang in there and you will be as good as new before too long.
Bill |
All times are GMT +9. The time now is 04:34 PM. |
Copyright EmailDiscussions.com 1998-2022. All Rights Reserved. Privacy Policy