Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

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

Search Support

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.

Learn More

Wo archive tread sia. Meɖekuku bia biabia yeye ne ehia kpeɖeŋu.

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 ŋuɖoɖo
  • 6 masɔmasɔ sia le wosi
  • 1 view
  • Nuɖoɖo mlɔetɔ Matt

passareg
passareg
more options

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)

Ŋuɖoɖo si wotia

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.

Xle ŋuɖoɖo sia le goya me 👍 1

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Ɖɔɖɔɖo si wotia

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.