Automating the generation of a report in PDF and sending it to an e-mail address

Hi, can someone please help. I have created a report and placed it on the SAGE desktop in OE reports folder. When I manually print and send this report to a particular email it works just fine. However, the recipient wants to receive this report automatically via e-mail at a scheduled time each day. I have tried to record a macro but for some reason, it only records up to the print stage and stops there. It does not capture the part where I Export the report to an e-mail address and include a subject and SEND. Is there a way I can e-mail this report automatically at a scheduled time each day?