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

All Replies (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!