Avatar for Username

সহায়তা খুঁজুন

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.

  • কোনো জবাব নেই
  • 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.