Results 1 to 6 of 6
  1. #1
    hogue@montana.com is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    How to e-mail from access to outlook


    I would like to send a single message to all of my E-Mail address.
    Db = database1
    Table = E-mail
    Field = E-Mail Address's

    My VBasic skills are nil

    Any help would be appreciated

    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,853
    You will have to use VBA. Common topic. Search forum and Google. Here is a start:

    https://www.accessforums.net/import-...ook-18221.html

    https://www.accessforums.net/access/...ect-17713.html
    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.

  3. #3
    hogue@montana.com is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    Hogue

    Thanks June7 will give it a try.

  4. #4
    hogue@montana.com is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    hogue

    Still trying June7, I can't find anything I can work with.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,853
    The example at Blue Claw was the closest I could find. It shows cycling through a recordset to send individual emal to each address. It uses a clone recordset of an open form. Could instead open a recordset from a table.

    You will have to learn VBA to build and maintain this process.

    The other links show use of other properties of the mail object. There is no one-stop source for email code. Have to pull together from multiple references.
    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.

  6. #6
    hogue@montana.com is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    Hogue

    OK June Thanks

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

Posting Permissions

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