Results 1 to 4 of 4
  1. #1
    wasmithpfs is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    2

    Automatically emailing a report via Access and Outlook

    Hi--I am using Access 2007 and want to automatically email reports that are generated in Access through Outlook.

    I have all of the steps down--running the queries, populating and formatting the report, attaching the report and having the reciepients and message text ready to go--all running as macros. However, when the Outlook window opens, I still have to click "send." I do not want to have to click the send key. Is this new to Access/Outlook 2007/2010? An Outlook issue ? Exchange?

    My OS is Windows 7 Professional.

    Here is the sample macro code converted to VB:
    Option Compare Database
    '------------------------------------------------------------
    ' Macro1
    '
    '------------------------------------------------------------
    Function Macro1()


    On Error GoTo Macro1_Err
    DoCmd.SendObject acTable, "Table1", "", "recipient@recipient.com", "", "", "", "", True, ""

    Macro1_Exit:
    Exit Function
    Macro1_Err:
    MsgBox Error$
    Resume Macro1_Exit
    End Function


    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Check out the Edit argument of SendObject.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    wasmithpfs is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    2

    RE: Automatically emailing a report via Access and Outlook

    Pbaldy,

    Thanks for the tip--that did the trick

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Emailing Personalized Report
    By rgrwatson85 in forum Reports
    Replies: 3
    Last Post: 10-20-2011, 10:21 AM
  2. Emailing Report with Attachments
    By Rookie in forum Reports
    Replies: 1
    Last Post: 08-19-2011, 06:52 PM
  3. Emailing a report
    By prv in forum Access
    Replies: 1
    Last Post: 12-20-2010, 04:03 PM
  4. EMailing Through Access
    By mamta in forum Programming
    Replies: 5
    Last Post: 02-15-2010, 01:07 PM
  5. Emailing report at the Email content
    By ylivne in forum Reports
    Replies: 0
    Last Post: 07-07-2009, 05:31 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