We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Avatar for Username

Iskanje po podpori

Izogibajte se prevarantski tehnični podpori. Nikoli vam ne bomo naročili, da pokličete telefonsko številko ali nam pošljete osebne podatke. Sumljivo dejavnost prijavite z gumbom »Prijavi zlorabo«.

Več o tem

Ta tema je arhivirana. Postavite prosim novo vprašanje, če potrebujete pomoč.

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

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?

Izbrana rešitev

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.

Preberite ta odgovor v kontekstu 👍 0

Vsi odgovori (2)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Izbrana rešitev

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 Lastnik vprašanja
more options

Thanks Matt - I should have realised!