Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email from Access? (A2k (9.0.3821) SR-1)

    I need code to send email from an access database via AOL without using Outlook

    Is that possible?

    I thought I had a sample db that demonstrated this and can

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Email from Access? (A2k (9.0.3821) SR-1)

    In general you can send email without using outlook using the command docmd.sendobject
    Look up help for the syntax..

    This will use your default email program, whatever that is.

    I have no experience with AOL, so i don't know if there are issues associated with that.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email from Access? (A2k (9.0.3821) SR-1)

    If you don't mind adding an external object to your project, you should consider ASPemail. Allows sending of email completely free of Outlook. It's available for free at aspemail.com.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  4. #4
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email from Access? (A2k (9.0.3821) SR-1)

    Just another vote for ASPEmail. I use it myself. There is a 'pro' version which costs money, but the free version is very acceptable with it's abilities.

    Of course, if you are really adventurous, you can make your own smtp client. I have a VB sample if you want. (Needed a method of 'resending' filtered emails. Emails filtered by our Spam filter go to the user with a 'default blocked' message. Sometimes there is a falsely blocked email.)

    Drew

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email from Access? (A2k (9.0.3821) SR-1)

    Hi Drew

    You can send me a copy.

    Thanks, John

  6. #6
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email from Access? (A2k (9.0.3821) SR-1)

    Actually, zipped, its pretty small, so I'll post it. I removed my smtp servers address, you'll have to put that in. Also, 'review' the code to see how it works, it's a pretty bare bones utility I wrote.

    Drew
    Attached Files Attached Files

Posting Permissions

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