This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

ค้นหาฝ่ายสนับสนุน

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.

เรียนรู้เพิ่มเติม

หัวข้อนี้ถูกเก็บถาวรแล้ว โปรดถามคำถามใหม่หากคุณต้องการความช่วยเหลือ

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!