Avatar for Username

Kërkoni te Asistenca

Shmangni karremëzime gjoja asistence. S’do t’ju kërkojmë kurrë të bëni një thirrje apo të dërgoni tekst te një numër telefoni, apo të na jepni të dhëna personale. Ju lutemi, raportoni veprimtari të dyshimtë duke përdorur mundësinë “Raportoni Abuzim”.

Mësoni Më Tepër

Kjo rrjedhë është arkivuar. Ju lutemi, bëni një pyetje të re, nëse keni nevojë për ndihmë.

mailmerge address field

  • 2 përgjigje
  • 1 e ka hasur këtë problem
  • 53 parje
  • Përgjigjja më e re nga 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?

Zgjidhje e zgjedhur

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.

Lexojeni këtë përgjigje brenda kontekstit 👍 1

Krejt Përgjigjet (2)

Lampros
Lampros
more options

Zgjidhja e Zgjedhur

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.

Ndryshuar nga Lampros

Fabio
Fabio I zoti i pyetjes
more options

Great! Worked!

Thank you