Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access and Thunderbird (All)

    Hi

    Does Thunderbird have a macro/VBA type language that would allow it to be controlled from MS Access? I.e. is it possible to generate multiple emails from MS Access through Thunderbird in the same way as can be done through Outlook?

    David

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access and Thunderbird (All)

    Yes

    I think you could use something like this:

    Public Function fSendThunderbird(strTo As String, strSubject As String, strBody As String)

    'This function can be used to send an e-mail from Mozilla Thunderbird.
    'The syntax for calling Thunderbird from a command line (DOS prompt) is:
    '
    'thunderbird -compose "mailto:somebody@somewhere?cc=address@provider&sub ject=hi&body=something"
    '
    Dim strCommand As String

    strCommand = "C:Program FilesMozilla Thunderbirdthunderbird"

    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)

    End Function


    I won't claim this for my own but can be found here: http://forums.mozillazine.org/viewtopic.php?t=399230&
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access and Thunderbird (All)

    For simple e-mails, you can use DoCmd.SendObject in Access VBA, e.g.

    DoCmd.SendObject To:="you@somewhere.com", Subject:="Test", Message:="Hello World", EditMessage:=True

    This will use the user's default e-mail application, there is no need to specify the name and path of the application.

    Using Automation to control Outlook from Access offers more features, such as adding attachments, setting the mail's priority and specifying HTML for the body of the e-mail. I think David wanted to know whether something similar is possible for Thunderbird.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access and Thunderbird (All)

    OK

    Read the message differently but see your point.
    Jerry

  5. #5
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Thunderbird (All)

    Thanks guys. I think the answer is stick with Outlook for anything other than very simple emails..

    I had hoped to get away with using Outlook for work and Thunderbird for the 2 associations I maintain databases for (using 2 Thunderbird profiles). It looks like the only way forward is to create 3 Windows/Exchange profiles with Outlook in each. Messy having to log out and login to change.

    David

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Thunderbird (All)

    Neither Firefox nor THunderbird support using VB/VBA directly.

    As was pointed out elsewhere, you can shell commands, but that's not really satisfactory.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access and Thunderbird (All)

    > As pointed out elsewhere

    Where? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    It would be nice to cross reference please
    Jerry

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Thunderbird (All)

    in this thread, posted by you.

  9. #9
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access and Thunderbird (All)

    So what do you suggest then? It is quick and easy to say something is not good enough but why don't you seek a constructive alternative before running an idea down.
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •