Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email Remittance Advices (2003 allSPs)

    I have a report which gets ODBC data from an Accounting package. In this case, this includes details of payments made to Suppliers. I want to be able to email the particulars of payments made to the Suppliers individual email addresses. I have the report working fine but dont know how to get it to produce the individual emails
    Any help appreciated
    TIA
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Email Remittance Advices (2003 allSPs)

    What i do in that case is open the report (using a where clause to limit it to the specific Supplier) , then use Docmd.SendObject to send the report as a snapshot. The report that is open is used so it only shows the supplier that is open.

    If i want to send them in batch I have a loop to work through the suppliers one at a time. Open the report, send it, close it, Open next one etc.

    If you want to send it as a pdf, you need to use Outlook automation rather than SendObject.
    Regards
    John



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

    Re: Email Remittance Advices (2003 allSPs)

    See <post:=275,460>post 275,460</post:> for sample code.

Posting Permissions

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