Results 1 to 4 of 4
  1. #1
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212

    Latest ideas on using email from within Access


    I would like to create an easy email interface associated with a notes file on a form. The notes file would represent reminders to the user and ideally, the user could create an email while looking at the notes file. If it could be any email, not just outlook, that would be a real plus. So it could be a second notes file, next to the first one where the email dialogue is created and then sent to email, or is it possible to open up a small window of an email application on top of the form with the notes file. Any thoughts would be welcome.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make a form to pick the record you want to show/send.
    A list box of the users to get the mail. I had code that when send btn is clicked it would cycle thru the list sending an email to each.
    It also could send to only 1 person by dbl-clicking on the 1 name in the list.

    Code:
    '------------
    Public Sub ScanAndEmail()
    '------------
    Dim vTo, vSubj, vBody, vRpt
    Dim vFilePath
    dim i as integer
    
    vRpt = "rReport1"
    vQry = "qsData"
    vBody = "body of email"
    vSubj = vRpt
    
         'scan the list box
    For i = 0 To lstEAddrs.ListCount - 1
       vItm = lstEAddrs.dataitem(i)
       lstEAddrs = vItm
       vTo = lstEAddrs.Column(1)      'col 1 has name, col2 has email
         
          'send report
       DoCmd.SendObject acSendReport, vRpt, acFormatPDF, vTO, , , vSubj, vBody
    
          'send query as datasheet
       DoCmd.SendObject acSendQuery, vQry, acFormatXLSX, vTO, , , vSubj, vBody
    Next
    End Sub

  3. #3
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212
    Thanks. I will try this out as soon as I can and report back.

  4. #4
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212
    I have set up the code. It operates when I click on a Button but it is asking me for an object. I changed VRpt="Name of my form". I changed acSendReport to acSendform. Ideally I would just like to send the Notes field from the form.

    How does this code know which email is being used or does it default to Outlook?

    Thanks

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

Similar Threads

  1. Need ideas for email survey that includes pictures of employees
    By Gina Maylone in forum Database Design
    Replies: 3
    Last Post: 12-27-2013, 02:58 PM
  2. Access DB Upgrade Rollout / DB Structural Sync Ideas
    By damientaylorcreata in forum Access
    Replies: 4
    Last Post: 11-25-2012, 08:29 PM
  3. New to access, need ideas!
    By phenicie in forum Access
    Replies: 1
    Last Post: 12-27-2011, 05:55 PM
  4. help please. i need basic access privacy/protection ideas
    By helpporfavorplz in forum Security
    Replies: 1
    Last Post: 02-20-2010, 05:32 PM
  5. Replies: 0
    Last Post: 09-07-2009, 04:27 PM

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