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

Търсене в помощните статии

Избягвайте измамите при поддръжката. Никога няма да ви помолим да се обадите или изпратите SMS на телефонен номер или да споделите лична информация. Моля, докладвайте подозрителна активност на "Докладване за злоупотреба".

Learn More

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

  • Няма отговори
  • 0 имат този проблем
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.