We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Avatar for Username

Mozilla 도움말 검색

고객 지원 사기를 피하세요. 저희는 여러분께 절대로 전화를 걸거나 문자를 보내거나 개인 정보를 공유하도록 요청하지 않습니다. "악용 사례 신고"옵션을 사용하여 의심스러운 활동을 신고해 주세요.

자세히 살펴보기

이 쓰레드는 보존되었습니다. 만약 도움이 필요하시면 새로운 질문을 올려주세요.

How do I copy an EXCEL list into Thunderbird mailing list?

  • 3 답장
  • 4 이 문제를 만남
  • 5 보기
  • 최종 답변자: tjohnson

info4blake
info4blake
more options

I want to send a "Thank you" to a group of people who attended my surprise birthday party (75 People were there ... wow) I was given a list of email addresses created in an EXCEL file. How should I format the excel list and how do I copy it into Thunderbird?

Thanks

I want to send a "Thank you" to a group of people who attended my surprise birthday party (75 People were there ... wow) I was given a list of email addresses created in an EXCEL file. How should I format the excel list and how do I copy it into Thunderbird? Thanks

모든 댓글 (3)

tjohnson
tjohnson
more options

If I understand your question correctly, it sounds like you want to do a mail merge. To do this in Thunderbird, you need to install the Mail Merge extension.

Regarding copying the Excel list into Thunderbird, you need to save it as a CSV file. According to a review on the add-on's home page, it's important to select the option "MS-DOS Comma Separated (.csv)" from the file dialog.

To import the list of addresses into Thunderbird, you should then be able to follow the Step by Step (CSV) instructions given in the "About this Add-on" section on the add-on's home page.

글쓴이 tjohnson 수정일시

info4blake
info4blake 질문자
more options

Thanks for the response. I am an 85 year old novice and may not have made my problem as explicit as I should have. My first issue is how do I get the excel file copied into a functional address list within Thunderbird. I now understand that a coma, CSV file is needed ...... Now what do I do with it and Thunderbird to combine them?

Thanks again

Jim

tjohnson
tjohnson
more options

No problem, we're glad to help.

If you've exported the Excel list as a CSV file, the next step is to install the Mail Merge extension in Thunderbird. You can do that by opening the Add-ons Manager (Tools->Add-ons), and clicking on Mail Merge in the list of featured add-ons. Click on the button that says "+ Add to Thunderbird" and restart Thunderbird after the add-on has installed.

Once you've installed the extension, follow these instructions (which I've copied from the add-on's home page):

Step by Step: (CSV)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog
  1. Create a New Message ("File -> New -> Message")
  2. Add the Variable(s) to To, e.g.: {{Email}} or {{FirstName}} {{LastName}} <{{Email}}>
  3. Add the Recipients to Cc (optional) (variables are supported)
  4. Add the Recipients to Bcc (optional) (variables are supported)
  5. Add the Subject (variables are supported)
  6. Add the Body (variables are supported)
  7. Add the Attachments (optional)
  8. Click "File -> Mail Merge"
  9. Select "CSV" and check "Deliver Mode" and "Format"
  10. Add (individual) Attachments (optional) (variables are supported)
  11. Select "Filename" and check "Character Set", "Field Delimiter" and "Text Delimiter"
  12. Check "Start", "Stop" and "Pause" (optional)
  13. Click "OK"
The Draft Message is saved as Template in your Current Account and for each Recipient a New Message is automagically saved in your Outbox ("Local Folders -> Outbox"). Ready for Delivery: "File -> Send Unsent Messages"

If you need more help, feel free to ask! That's why we're here :-)

글쓴이 tjohnson 수정일시