While using mail merge, problem occurs when "inverted comma" comes in any of the email address in am sending to.
While bulk emails through mail merge, we are getting this problem. Don't no from where inverted comma comes in between one of the email I am sending. ex. shown below. If I am taking to email in "TO" option and three emails in "CC" option. It " " "suddenly come in any of the email
", , sheeba.johnson"@pearlacademy.com
การตอบกลับทั้งหมด (1)
This is not an issue with Thunderbird, nor really with the mail merge add-on it is a perennial issue with the CSV format and the constant need to massage the data to remove extraneous data like odd inverted commas. When this sort of data comes from say a web page, it is far easier to "standardize" what the user is allowed to input than it is to clean up the mess latter.
Have a look here http://stackoverflow.com/questions/4816424/are-single-quotes-legal-in-the-name-part-of-an-email-address
inverted commas while legal are frowned upon and most email providers do not allow them
Note that I have not tried this with mail merge, but often replacing a single quotation mark with three will side step the issue