VBA push button script for attaching PDF and email using Mozilla Thunderbird

Re: VBA push button script for attaching PDF and email using Mozilla Thunderbird

Problem is Thunderbird does not expose a COM interface so you cannot 'program' it directly like Outlook.

You can try using SendKeys' to send keystrokes to the ThunderBird app but you'll tear your hair out trying to get it to work consistently, or even at all. The only other option is to Shell Thunderbiard passing all the components to make up an email as parameters on the command line. for example:

Sub x


   Dim strCmd as String
   '// Example path only
   strCmd = "C:\Program Files\Mozilla Thunderbird\thunderbird" 
   strCmd  = strCmd  & " -compose " & Chr$(34) & "mailto:" & strTo & "?" 
   strCmd  = strCmd  & "subject=" & Chr$(34) & strSubject & Chr$(34) 
   strCmd  = strCmd  & strBody 
   
   Call Shell(strCmd, vbNormalFocus)

Where strTO and strSubject have been populated earlier in the code (saving my time here)
Note also that ThunderBird uses symbols after certain fields ('?' after the 'To' field as an example), you need to investigate these, I'm not sure of all the conventions used.

Attachments can be added using something like

strCmd  = strCmd  & "attachment=" & strAtt   '// Again defined and populated elsewhere

But again you need to check the exact syntax.

(Rough 'pseudo' code - I'm not saying it is correct or will run - just to illustrate how. I don't have access to ThunderBird so cannot test)

Re: VBA push button script for attaching PDF and email using Mozilla Thunderbird

Quote

Will I be able to just paste this in and it will work

Quote from Cytop

I'm not saying it is correct or will run - just to illustrate how

Please actually read my previous post.

If you are a beginner with VBA then unfortunately you are going to have some issues with this but it will be an excellent learning experience if, rather than just looking for 'ready made' code, you do actually want to learn.

I can't help with specifics as I don't have (and don't want) Thunderbird, but I'd be happy to help with the VBA syntax. That leaves investigating the Thunderbird command line syntax down to you.