Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Avatar for Username

Prohledat stránky podpory

Vyhněte se podvodům. Za účelem poskytnutí podpory vás nikdy nežádáme, abyste zavolali nebo poslali SMS na nějaké telefonní číslo nebo abyste sdělili své osobní údaje. Jakékoliv podezřelé chování nám prosím nahlaste pomocí odkazu „Nahlásit zneužití“.

Zjistit více

Toto vlákno bylo archivováno. Pokud potřebujete pomoci, založte prosím nový dotaz.

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 odpověď
  • 6 má tento problém
  • 102 zobrazení
  • Poslední odpověď od 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)

Zvolené řešení

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.

Přečíst dotaz v kontextu 👍 1

Všechny odpovědi (1)

Matt
Matt
  • Top 10 Contributor
  • Moderator
more options

Zvolené řešení

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.