• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by User Bot


25 Apr, 2025

Updated at 20 May, 2025

VBA send email from a second account using thunderbird

I use an excel to send my invoices by mail. Until now i used outlook (i have a different email address for invoices). I use thunderbird for day to day. I added my invoice email as my second account in thunderbird. I need a way for the excel to chose the second email address (the default one is the one i use day to day). I dont't want to change de default mail in thunderbird everytime i send an invoice. This is the code i use to send mail from thunderbird (this works for the default email address) ''' thund = "C:\Program Files\Mozilla Thunderbird\thunderbird.exe " & _ "-compose " & """" & _ "to='" & email & "'," & _ "cc='" & cc & "'," & _ "bcc='" & bcc & "'," & _ "subject='" & subj & "'," & _ "body='" & body & "'" & """" ''' I tried using (i found online some exemples in outlook - they didn't work) "SendUsingAccount ='" & "[email protected]" & "'," & _ "SentOnBehalfOfName='" & "[email protected]" & "'," & _