Questa discussione è archiviata.
Inserire una nuova richiesta se occorre aiuto.
Stato della soluzione
Archiviato
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?
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)
Tutte le risposte (1)
Soluzione scelta
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.