Windows 10 reached EOS (end of support) on October 14, 2025. If you are on Windows 10, see this article.

Avatar for Username

Sykje yn Support

Mij stipescams. Wy sille jo nea freegje in telefoannûmer te beljen, der in sms nei ta te stjoeren of persoanlike gegevens te dielen. Meld fertochte aktiviteit mei de opsje ‘Misbrûk melde’.

Mear ynfo

Dizze konversaasje is argivearre. Stel in nije fraach as jo help nedich hawwe.

Sending an email from Excel VBA builds the message okay but I do not know how to tell thunderbird to "sendnow". How do I structure the command?

  • 1 antwurd
  • 6 hawwe dit probleem
  • 152 werjeftes
  • Lêste antwurd fan Matt
  • Oplost

passareg
passareg

This is the code I am using to access the command line to thunderbird. What do I need to send to Thunderbird send the email that has been built?

Dim strCommand As String 

strCommand = "C:\Program Files\Mozilla Thunderbird\thunderbird"
strCommand = strCommand & " -compose " & Chr$(34) & "mailto:" & strTo & "?"
strCommand = strCommand & "subject=" & Chr$(34) & strSubject & Chr$(34) & "&"
strCommand = strCommand & "body=" & Chr$(34) & strBody & Chr$(34)

Call Shell(strCommand, vbNormalFocus)
This is the code I am using to access the command line to thunderbird. What do I need to send to Thunderbird send the email that has been built? Dim strCommand As String strCommand = "C:\Program Files\Mozilla Thunderbird\thunderbird" strCommand = strCommand & " -compose " & Chr$(34) & "mailto:" & strTo & "?" strCommand = strCommand & "subject=" & Chr$(34) & strSubject & Chr$(34) & "&" strCommand = strCommand & "body=" & Chr$(34) & strBody & Chr$(34) Call Shell(strCommand, vbNormalFocus)

Keazen oplossing

The automated sending of mail is just not supported. It is exceedingly difficult to get malware to spew spam with your mail client if it does not have an automated send option.

I suggest you use vbs > SMTP code to send your mail. If you use Google or Outlook.com the mail sent using the SMTP server will sync to the sent folder.

Dit antwurd yn kontekst lêze 👍 1

Alle antwurden (1)

Matt
Matt
  • Top 10 Contributor

Keazen oplossing

The automated sending of mail is just not supported. It is exceedingly difficult to get malware to spew spam with your mail client if it does not have an automated send option.

I suggest you use vbs > SMTP code to send your mail. If you use Google or Outlook.com the mail sent using the SMTP server will sync to the sent folder.