Results 1 to 2 of 2
  1. #1
    SAugsburger is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    6

    Automating email from form for both To: and From: fields


    I have a legacy MS Access 2003 database running on a Windows XP machine and I am trying to upgrade the client machines up to Windows 7 x64, but the third party mail component that I was using an old version of the Chilkat v7.9 mail dll is a 32-bit library that I can't register on a Windows 7 x64 machine. &nbsp;So I am trying to retain the email form functionality where I can assign the from: line, but I was curious upon what would be a good solution to replace this functionality. &nbsp;The SendObject command doesn't appear to allow for assigning the from line and neither does the newer&nbsp;EMailDatabaseObject that was added in Access 2010 so unless I am missing something I need a third party library that will be accessed via an VB module of some kind to retain such functionality when upgrading the old Access 2003 database to Access 2013.<br> <br>&nbsp;In searching I stumbled upon&nbsp;Total Access Emailer (https://www.fmsinc.com/MicrosoftAccess/Email.asp). &nbsp;It doesn't explicitly mention Access 2013 although I presume it is probably supported. &nbsp;What would be some good options for solving my issue?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Don't have Outlook Exchange?

    Perhaps CDO (Collaboration Data Object) will work for you. It's possible that's what the Total Access Emailer uses.

    http://bytes.com/topic/access/answer...-using-cdo-vba
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-11-2013, 10:05 PM
  2. Replies: 1
    Last Post: 09-21-2013, 07:54 PM
  3. Automating a process with a form
    By Topper in forum Forms
    Replies: 2
    Last Post: 06-12-2013, 09:14 AM
  4. Email to outlook based off fields in a form
    By jcbrackett in forum Programming
    Replies: 4
    Last Post: 03-07-2012, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums