T-code SCOT
T-Code RSCRM_BAPI
Tx: RSRT
You dont need portal to broadcast queries using Bex Broadcater.You can call BEx Broadcaster from Bex Analyzer,Query designer and from context menu of web template.The pre-requisite is to have mail server configured in ur system.Check the same using T-code SCOT ask for basis help in configuring mail server.Alternatively u can also schedule reports expoting to excel using T-Code RSCRM_BAPI but it has lot of limitations.The best solution would be through BEx Broadcater.try to search in forum for more information.
There is one more way to get the report in excel form .
goto Tx: RSRT select the requested query and Query display = HTML.
now Execute after that you will get the output of the query.
goto information Broadcasting tab.
with this feature you can directly send this report to the email.
RFC error when sending logon data
