Avatar for Username

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.

Rohkem teavet

Teema arhiveeriti. Please ask a new question if you need help.

While using mail merge, problem occurs when "inverted comma" comes in any of the email address in am sending to.

  • 1 vastus
  • 1 on selline probleem
  • 3 views
  • Viimati vastas Matt

irajeevattri
irajeevattri
more options

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

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

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

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