Results 1 to 3 of 3
  1. #1
    Ganymede is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    64

    Email with attachment

    Reference https://www.accessforums.net/access/...ail-24962.html


    This looks great. I only wish I could use it. I keep getting the "User-type not defined issue" error for DAO.Recordset2. Not sure why. I have DAO 3.6 enabled.

    And I get a "method not found" error for savetofile. Not sure what reference I need to enable.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,920
    I don't have DAO library reference set and all my code using DAO works. If you want to provide project I will look at. Follow instructions at bottom of my post.

    I am splitting your post to a new thread.
    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
    Ganymede is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    64
    June7,

    I appreciate the offer, but I don't really have much to show yet. I simply copied/pasted the code from the previous thread and binded that code to a form button. I knew it wouldn't work right away because I hadn't tailored it to my DB. However, I wanted to make sure there were no reference errors before I put the effort in. Unfortunately, my DB is not recognizing DAO.Recordset2, Field2 or Savetofile.

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

Similar Threads

  1. Mailmerge an Email with an attachment
    By Baldeagle in forum Access
    Replies: 8
    Last Post: 05-21-2012, 02:21 PM
  2. Replies: 1
    Last Post: 03-09-2011, 08:54 AM
  3. Send in Email Body vice Attachment
    By cassidym in forum Programming
    Replies: 2
    Last Post: 10-20-2010, 06:21 AM
  4. Beginner trying to send email with attachment
    By ahm in forum Programming
    Replies: 2
    Last Post: 03-24-2009, 08:51 PM
  5. email attachment from Access
    By Gandalf in forum Queries
    Replies: 0
    Last Post: 01-22-2009, 10:03 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