RE: Auto email reports to 200 Suppliers

Thanks for the simple solution, Tommie. I tried it and it works!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
Sent: Monday, July 07, 2008 8:19 AM
To: Midrange Systems Technical Discussion
Subject: Re: Auto email reports to 200 Suppliers

a quick and dirty way would be to create a duplicate file and write out
the headers then CPYF mbropt(*add) to the file and send *that* file
instead. then the first record would contain the headers.

Thanks,
Tommy Holden



From:
"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
To:
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Cc:
Ben Summers <bsummers@xxxxxxxxxxxxx>
Date:
07/07/2008 08:17 AM
Subject:
Auto email reports to 200 Suppliers



Greetings,

I have put together a "free procedure" which runs as a scheduled job,
and emails out Open Order reports (in Excel format) to 200+ suppliers.

The main steps used are:

CPYSPLF
Runqry (to Select out only the detailed lines) CALL PGM(SENDFILE)
CPYTOIMPF CPYTOPCD SNDDST

This is working fine, except for one thing - many of the Suppliers
receiving the Email attachment want HEADERS. However, headers are NOT
included in my automated procedure.

I'm wondering if anyone has a workaround to automatically include the
headers?

Thanks,
Don C.


Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman