Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

On Monday the 3rd of March, around 5pm UTC (9am PT) users may experience a brief period of downtime while one of our underlying services is under maintenance.

Avatar for Username

ძიება მხარდაჭერაში

ნუ გაებმებით თაღლითების მახეში. აქ არავინ უნდა მოგთხოვოთ ტელეფონზე დარეკვა, შეტყობინების გაგზავნა ან პირადი მონაცემების გაზიარება. რამე საეჭვოს შემჩნევისას გთხოვთ გვაცნობოთ „დარღვევის მოხსენებით“.

ვრცლად

ეს თემა დაარქივებულია. დასვით ახალი კითხვა, თუ დახმარება გესაჭიროებათ.

Sending an email from Excel VBA builds the message okay but I do not know how to tell thunderbird to "sendnow". How do I structure the command?

  • 1 პასუხი
  • 6 მომხმარებელი წააწყდა მსგავს სიძნელეს
  • 93 ნახვა
  • ბოლოს გამოეხმაურა Matt

passareg
passareg
more options

This is the code I am using to access the command line to thunderbird. What do I need to send to Thunderbird send the email that has been built?

Dim strCommand As String 

strCommand = "C:\Program Files\Mozilla Thunderbird\thunderbird"
strCommand = strCommand & " -compose " & Chr$(34) & "mailto:" & strTo & "?"
strCommand = strCommand & "subject=" & Chr$(34) & strSubject & Chr$(34) & "&"
strCommand = strCommand & "body=" & Chr$(34) & strBody & Chr$(34)

Call Shell(strCommand, vbNormalFocus)
This is the code I am using to access the command line to thunderbird. What do I need to send to Thunderbird send the email that has been built? Dim strCommand As String strCommand = "C:\Program Files\Mozilla Thunderbird\thunderbird" strCommand = strCommand & " -compose " & Chr$(34) & "mailto:" & strTo & "?" strCommand = strCommand & "subject=" & Chr$(34) & strSubject & Chr$(34) & "&" strCommand = strCommand & "body=" & Chr$(34) & strBody & Chr$(34) Call Shell(strCommand, vbNormalFocus)

გადაწყვეტა შერჩეულია

The automated sending of mail is just not supported. It is exceedingly difficult to get malware to spew spam with your mail client if it does not have an automated send option.

I suggest you use vbs > SMTP code to send your mail. If you use Google or Outlook.com the mail sent using the SMTP server will sync to the sent folder.

პასუხის ნახვა სრულად 👍 1

ყველა პასუხი (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

შერჩეული გადაწყვეტა

The automated sending of mail is just not supported. It is exceedingly difficult to get malware to spew spam with your mail client if it does not have an automated send option.

I suggest you use vbs > SMTP code to send your mail. If you use Google or Outlook.com the mail sent using the SMTP server will sync to the sent folder.