본 사이트는 여러분의 사용자 경험을 개선하기 위해 유지 보수를 진행하는 동안 기능이 제한됩니다. 도움말로 문제가 해결되지 않고 질문을 하고 싶다면 Twitter의 @FirefoxSupport 및 Reddit의 /r/firefox 채널을 활용하세요.

Avatar for Username

Mozilla 도움말 검색

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

자세히 살펴보기

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

mailmerge address field

  • 2 답장
  • 1 이 문제를 만남
  • 1 보기
  • 최종 답변자: Fabio

Fabio
Fabio
more options

I tried to use mailmerge for customizing a series of emails. My database is a spreadsheet (but I tried with a CSV file as well) with the following fields: "firstname", "lastname" and "email". I put {{email}} in the "To:" field of the message and {{firstname}} in the body. However when I try to use mailmerge I receive an error message: "The address is not valid: please put a valid address in the "To:" field".

If I put a valid address in the field (johndoe@mymail.com) and {{email}} in the BCC field, the messages are well composed (the first names are in the proper place) but, of course, the only generated email is addressed to johndoe and the fileld Bcc is simply ignored.

It looks like Thunderbird does not accept {{email}} in the address fields but only in the body of the message.

What can I do?

I tried to use mailmerge for customizing a series of emails. My database is a spreadsheet (but I tried with a CSV file as well) with the following fields: "firstname", "lastname" and "email". I put {{email}} in the "To:" field of the message and {{firstname}} in the body. However when I try to use mailmerge I receive an error message: "The address is not valid: please put a valid address in the "To:" field". If I put a valid address in the field (johndoe@mymail.com) and {{email}} in the BCC field, the messages are well composed (the first names are in the proper place) but, of course, the only generated email is addressed to johndoe and the fileld Bcc is simply ignored. It looks like Thunderbird does not accept {{email}} in the address fields but only in the body of the message. What can I do?

선택된 해결법

If you use Thunderbird 91.x.x. After you {{email}} in the "To:" field press enter. {{email}} will turn red. Press mail merge extension button .A message will show saying that the message has been saved as a template. Continue.


The menu of mailmerge extension will appear. Choose as source CSV (or spreadsheet) Browse the CSV file. Change field delimiter to , or ; according to the creation of the CSV file in excel (not nessesary step for spreadsheet). Press preview and you will see that the messages are bein prepared.

I believe same is valid for previous versions of Thunderbird.

문맥에 따라 이 답변을 읽어주세요 👍 1

모든 댓글 (2)

Lampros
Lampros
more options

선택된 해결법

If you use Thunderbird 91.x.x. After you {{email}} in the "To:" field press enter. {{email}} will turn red. Press mail merge extension button .A message will show saying that the message has been saved as a template. Continue.


The menu of mailmerge extension will appear. Choose as source CSV (or spreadsheet) Browse the CSV file. Change field delimiter to , or ; according to the creation of the CSV file in excel (not nessesary step for spreadsheet). Press preview and you will see that the messages are bein prepared.

I believe same is valid for previous versions of Thunderbird.

글쓴이 Lampros 수정일시

Fabio
Fabio 질문자
more options

Great! Worked!

Thank you