Join us and the lead editor of IRL, Mozilla's multi-award-winning podcast, for a behind-the-scenes look at the pod and to contribute your ideas for the next season, themed: "AI and ME." Mark your calendar and join our Community Call on Wednesday, Aug 7, 17:00–17:45 UTC. See you there!

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.

Learn More

Natao arisiva ity resaka mitohy ity. Mametraha fanontaniana azafady raha mila fanampiana.

Sending Emails using VBA from MS Access (DoCmd.SendObject). The first five characters of the email address are being cut off.

  • 1 valiny
  • 1 manana an'ity olana ity
  • 6 views
  • Valiny farany nomen'i Matt

bruce13
bruce13
more options

Using Thunderbird as my Email Client for sending out emails from Access 365. We recently updated (both Access and Thunderbird) and now I am seeing that the emails being sent from Access are having their email address cut off. The first 5 characters of all email address (TO, CC, BCC) are being cut off. HappyFamily@email.com --> Family@email.com Is this an access issue or a Thunderbird issue?

Using Thunderbird as my Email Client for sending out emails from Access 365. We recently updated (both Access and Thunderbird) and now I am seeing that the emails being sent from Access are having their email address cut off. The first 5 characters of all email address (TO, CC, BCC) are being cut off. HappyFamily@email.com --> Family@email.com Is this an access issue or a Thunderbird issue?

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

it might be a character set issue. Most of the office suite are yet to make the leap to unicode, so simple unicode CSV files throw excel for instance into a loop where it wants to "import" the text file.

My guess, and it is a guess, is that your seeing one of the oddities of ansi to unicode in Microsoft office. A starting point might be to make sure windows is actually using unicode.