我使用Excel VBA通过命令行参数在Thunderbird中创建电子邮件,相关信息可以在此处找到:http://kb.mozillazine.org/Command_line_arguments_%28Thunderbird%29。邮件的撰写已经完成,但如何实现自动发送呢?
或者,是否有一个按钮可以一次性发送所有撰写好的邮件?
以下是VBA代码:
或者,是否有一个按钮可以一次性发送所有撰写好的邮件?
以下是VBA代码:
Option Explicit
Sub thunderbird()
Dim strTh As String
Dim strCommand As String
strTh = "C:\Program Files (x86)\Mozilla Thunderbird\thunderbird.exe "
strCommand = strCommand & " -compose " & "to=" & Chr(34) & "foo@bar.de" & Chr(34)
strCommand = strCommand & ",preselectid=id2"
strCommand = strCommand & ",subject=" & Chr(34) & "wow so email" & Chr(34)
strCommand = strCommand & ",body=" & Chr(34) & "anything" & Chr(10) & "more" & Chr(34)
Call Shell(strTh & strCommand, vbNormalFocus)
End Sub