Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

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

I am trying to send emails from a VBA code, and it works sometimes and sometimes not.

  • Atsakymų nėra
  • 0 have this problem
Phillip Abookire
Phillip Abookire
more options

My code is as follows: thund = "C:\Program Files (x86)\Mozilla Thunderbird\thunderbird.exe " & _ 

       "-compose " & """" & _
       "to='" & email & "'," & _
       "attachment='" & Attachment$ & "'," & _
       "subject='" & subj & "'," & _
       "body='" & fullBody$ & "'" & """"
   Call Shell(thund, vbNormalFocus)
   Sleep 3000
   AppActivate "thunderbird"
   SendKeys "^~", True
   Sleep 3000

   SendKeys "^{ENTER}", True
   Sleep 3000

   SendKeys "%fd", True
My code is as follows: thund = "C:\Program Files (x86)\Mozilla Thunderbird\thunderbird.exe " & _ "-compose " & """" & _ "to='" & email & "'," & _ "attachment='" & Attachment$ & "'," & _ "subject='" & subj & "'," & _ "body='" & fullBody$ & "'" & """" Call Shell(thund, vbNormalFocus) Sleep 3000 AppActivate "thunderbird" SendKeys "^~", True Sleep 3000 SendKeys "^{ENTER}", True Sleep 3000 SendKeys "%fd", True

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.