RE: MAPICS Reports to email

Bryan,
        Would you be willing to share some of your CL programs.

Contact me offlist at banderson    at   kentwatersports    dot    com

Bob Anderson
EDI Coordinator
Kent Sporting Goods Inc.
New London OH 44851
419-929-7021 x315
419-929-1380 FAX

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Burns, Bryan
Sent: Thursday, January 20, 2005 3:12 PM
To: MAPICS ERP System Discussion
Subject: RE: MAPICS Reports to email


Lloyd,

Be sure to check out SPLTOOL at www.bvstools.com.

We use it to distribute 17 of our nightly reports, which I used to have to
print and distribute.  I modified the nightly CL to use one of the SPLTOOL
commands to take a spooled file, convert it to a PDF and e-mail it.  I am
not a programmer but know a little CL and was able to learn how to use the
SPLTOOL command to incorporate them into a CL.  I also use it to email all
our all our accounting and sales month end reports to myself as PDF's, which
I then paste them to shared network drives.

When doing my investigation, I looked at other products too, but it looked
to me like SPLTOOL was the easiest to configure. After using it for several
years, I am glad I recommended it.  We have some "users" in customer service
who are not really computer savvy but they use the SPLTOOL product on a
daily basis to mail their own spooled files to distributors.

You can download the program and test it without having to buy anything or
feel committed to it.  The site says SPLTOOL has over 20,000 downloads.

Hope this helps.  Contact me off list if you would like.



-----Original Message-----
From: LDegnon@xxxxxxxxx [mailto:LDegnon@xxxxxxxxx]
Sent: Thursday, January 20, 2005 1:16 PM
To: MAPICS ERP System Discussion
Subject: RE: MAPICS Reports to email


Thanks to all for the input.  I guess it's time to start trying these
out...



Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx
www.AmPro.com



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of LDegnon@xxxxxxxxx
Sent: Wednesday, January 19, 2005 9:43 AM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS Reports to email

Is anyone out there using anything to automatically run reports on a
scheduled basis and export them into Excel Format and email them? I am
looking at SpoolIT, but it seems like it is quite cumbersome to set up.
I also don't like the fact that I have to have the application, SpoolIT
server, and SpoolIT Scheduler running on my P.C.  Also, it seems kind of
temperamental.  I am sure that there are other products that can do
this, any ideas?



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 1/19/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 1/19/2005