Avatar for Username

搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信，及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

话题已存档。 如果需要帮助请提出新问题。

Automating Thunderbird from Excel VBA - problem with vbNewline in message body

  • 2 个回答
  • 1 人有此问题
  • 121 次查看
  • 最后回复者为 billhislop210

billhislop210
billhislop210
more options

I am using VBA from Excel to provide an automated set of emails using the Thunderbird command line (thunderbird -compose). When the message body is something like "String1" & vbNewLine & "String2", the email message body comes out as the newline first, then String1 the String2. I've tried several variations such as using vbCRLF, CHR$(10), etc. but they all do the same thing.

Any ideas anyone?

I am using VBA from Excel to provide an automated set of emails using the Thunderbird command line (thunderbird -compose). When the message body is something like "String1" & vbNewLine & "String2", the email message body comes out as the newline first, then String1 the String2. I've tried several variations such as using vbCRLF, CHR$(10), etc. but they all do the same thing. Any ideas anyone?

被采纳的解决方案

vbnewline inserts a carriage control and line feed pair into the text. chr$(10) and chr$(11) if I remember from 20 years ago.

The Thunderbird composer uses HTML, so what you need to do is send a HTML paragraph not and windows ascii line feed.

定位到答案原位置 👍 0

所有回复 (2)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

选择的解决方案

vbnewline inserts a carriage control and line feed pair into the text. chr$(10) and chr$(11) if I remember from 20 years ago.

The Thunderbird composer uses HTML, so what you need to do is send a HTML paragraph not and windows ascii line feed.

billhislop210
billhislop210 提问者
more options

Thanks Matt - I should have realised!