Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Email or Exporting (2003)

    I currently use
    <pre>DoCmd.SendObject acReport, "rpt-V-Cmt-AshGrove", acFormatSNP, _
    "someone@somewhere.com", , , "L.H. Lacy Material Schedule", _
    "Here is this weeks Material Schedule.", False</pre>

    to send reports.

    I have run into a situation where I would like to send 2 or 3 reports in a single emal.
    1) How do I add multiple attachments to an email?
    or
    2) If I could export these reports in SNP to a folder, then attach them, how would i go about this?

    Thanks,
    Jackal

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email or Exporting (2003)

    You can't use SendObject to send multiple attachments. If you use Outlook, you can control it from Access using Automation. See MSKB article How to use Automation to send a Microsoft Outlook message using Access 2000. The sample code can be modified to attach more than one file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •