Automating Thunderbird from Excel VBA - problem with vbNewline in message body
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)
선택된 해결법
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.
Thanks Matt - I should have realised!