Automate reports

[Ielamrani]

Hi,
I ran reports once a day (at 4PM or later) then these reports are exported to two separate excel sheets one called: DailyAuth and the other called: DailyAuthMCR. Then I use 2 email templates to email the 2 sheets.

One template called: Daily Authorizations sent to a group of people with the DailyAuth sheet attached to it
The other template called: Daily Authorizations MCR sent to another group of people with the DailyAuthMCR sheet attached to it

Is there a way to make this process one button click. Meaning once I ran the reports I click on a button which will attached the 2 excel sheet to the email and email them to the list of people.

I hope this is clear

Thanks in advance
Ismail

 

[rstitzel]

You can create a MACRO and use The SENDOBJECT command to take your report convert it to an excel spreadsheet and send it out to a list of email addresses all at one time.

 

[Ielamrani]

that's it. thank you.
to be honest with you I never used the SENDOBJECT Command before.
Ismail

 

[mp9]

Once you've got the macro set up, consider using the Handy Access Launcher (HAL) to schedule the macro runs with no further action from you required.

HAL is available from

http://www22.brinkster.com/accessory/resources/001.shtml

 

[Ielamrani]

THANK YOU