Results 1 to 3 of 3
  1. #1
    Mike Cooper is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2006
    Location
    Europe
    Posts
    6

    E-mail Reports

    Hi,

    I have a set of reports that print from a macro without using the preview option. I was wondering if I could send the reports by e-mail instead of print them to a group of various people.

    What macro should I use ?

    Thanks



    Mike

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    I'm thinking SendObject.

  3. #3
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear Mike,

    You can modify your macro to send the report by e-mail ... check the following steps:

    Open your macro in design view
    In action select (SendObject)
    In action argument you can select the object type, name, output format and other sending parameters (TO / CC / subject / message)

    Also you can insert a commans button to send this report
    Write the following in (on click)

    DoCmd.SendObject acReport, "REPORT_NAME", "SnapshotFormat(*.snp)", "TO", "CC", "BCC", "SUBJECT", "MESSAGE", False, ""

    Thanks

    Ahmed

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

Similar Threads

  1. Need Help on reports
    By MeehPhill in forum Reports
    Replies: 3
    Last Post: 07-31-2006, 11:51 AM
  2. Mail merge
    By grgerhard in forum Forms
    Replies: 0
    Last Post: 04-25-2006, 05:06 PM
  3. Mail Merge problem
    By kfergus in forum Programming
    Replies: 0
    Last Post: 04-24-2006, 01:06 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