Results 1 to 3 of 3
  1. #1
    Stettler is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Location
    Stettler, Alberta
    Posts
    1

    E-mail generated from Access form is attaching table of whole database on windows upgraded computers

    I am a novice in Access but managed to generate a database with a form that e-mails the data in the form to the employee selected with several details for the data for which you have just entered (mainly a customer initiated contact) which we have been using for almost two years without problems.



    We are upgrading our computers and I am finding that the Access program on the computers that have been upgraded to Windows 2019 now ask what format to send the data in when we click on the e-mail button "text, HTML, Etc", we have never attached a table to the e-mail before, we have been selecting TXT because it seems to attach it faster (although still slow) and then we delete it out of the e-mail, there is no need to have the database attached to each e-mail and I have never written any additional code that has asked for this to happen.

    Is there something that can be changed in settings so that this does not happen, this only happens for the computers that have been updated to Windows 2019. The database is a shared database and those persons who generate an item in the database but do not have upgraded computers are not asked to attach the table to their e-mails.

    Thank you,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Post the code that generates email.
    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
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Attach a query (recordset) of the data you want to filter the records.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-23-2019, 03:31 PM
  2. Replies: 6
    Last Post: 03-14-2019, 05:47 PM
  3. Replies: 13
    Last Post: 05-10-2017, 01:45 PM
  4. Replies: 1
    Last Post: 05-10-2011, 09:48 AM
  5. Windows 7 and smtp mail with Access 2003
    By mafhobb in forum Programming
    Replies: 1
    Last Post: 06-28-2010, 09:05 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