TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • July 24, 2000 at 8:23 am #2079385

    AS/400 to Excel to Email

    Locked

    by kathleen.f.gonzalez · about 24 years, 7 months ago

    I need to set up an automatic process that will take database files from the AS/400, import into Excel to be formatted (macro?), and then email to a specified recipient list. I’ve found several products that will do this with spool files, but not much for db files. Any ideas?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • July 24, 2000 at 3:41 pm #3773774

      AS/400 to Excel to Email

      by lump_16 · about 24 years, 7 months ago

      In reply to AS/400 to Excel to Email

      I’m very new to the AS/400.
      AS/400 and Excel files are 2 differnet formats arn’t they?

      I’d like to know a bit more about how that process works too.

      Brian Wright
      Computer Information Systems student
      Terra Community college
      Fremont, Ohio

    • July 25, 2000 at 1:06 am #3773713

      AS/400 to Excel to Email

      by melodyj · about 24 years, 7 months ago

      In reply to AS/400 to Excel to Email

      Perhaps Access is your answer… You could create a macro that imports/links the file using the file spec that you create and then send the file out in .XLS format (sendobject).

      Regards,
      Melody

  • Author
    Replies
Viewing 1 reply thread