Automate email

[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

 

[Frink]

Hallo,

Yes, there are lots of posts about emailing on this website.
Do a search, maybe in the Access Modules section.

- Frink

 

[mp9]

If you've created a macro or code to do this, consider then using the Handy Access Launcher (HAL) to schedule the running of the macro at regular pre-defined times, so you don't even have to open the db and click your button...

HAL is available from

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

 

[Ielamrani]

Thanks for the tip. I'll check the site
Ismail