Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

thunderbird mail merge

  • 4 odgovori
  • 3 ima ovaj problem
  • 1 view
  • Posljednji odgovor poslao Bill

more options

How do you determine if a field in the csv file is blank? {{{{name}}|==|| . . . doesn't seem to work if {{name}} is blank but does seem to work is {{name}} is not blank. I can't get my head around this.

How do you determine if a field in the csv file is blank? {{{{name}}|==|| . . . doesn't seem to work if {{name}} is blank but does seem to work is {{name}} is not blank. I can't get my head around this.

Izmjenjeno od strane Bill

All Replies (4)

more options

Mail Merge is designed to add a personal touch to sending out one email to several people in an address book or csv file. Each email is created separately, so it only uses the 'TO' field. It would be expected that your contact would have a name in order to personalise it. Edit the *.csv file or address book contacts as required.

If you created the .csv file from the Thunderbird Address Books or directly use an Address book then {{Name}} would not exist.

Thunderbird uses {{First Name}} {{Last Name}} inserted into an email template to pick up both of those fields and auto insert the correct name when creating the email.

more options

The {{Name}} or {{First Name}} {{Last Name}} has be the same as the column headers in the *.csv file. the *.csv file should be checked to ensure all data is correct for use.

more options

Thanks Toad-Hall, I have been using the Mail Merge add-on successfully for over a year now. But I have only recently tried to use conditional variables and I'm experiencing some difficulty, particularly in determining whether a field is blank (empty) or not. I tried the following tests: 1. BlankCell {{{{BlankCell}}|*||is blank|not blank}} 2. NonBlankCell {{{{NonBlankCell}}|*||is blank|not blank}} where {{BlankCell}} is a header in the csv file for a column containing blank (i.e. empty) cells and {{NonBlankCell}} is a header in the same csv file for a column containing non-blank cells. What I found was that test 1 produced no result at all and test 2 produced the incorrect result, "NonBlankCell is blank". It seemed to me that the "*" operator was more appropriate than "==" that I originally tried; but alas...

more options

The following works: {{Col. Hdg||is blank|not blank}} where "Col. Hdg" is the heading of a column in which cells may or may not be blank. This produces "is blank" or "not blank" depending on what is in each cell in the column. My thanks to Alexander Bergman who provided the solution.