I have various reports in MS Access which I send to different branches. I select the report and use the send command and the default email is Outlook Express and it goes without any problem. I have to, of course, select the branch from the Address Book and other parameters like the period etc depending on the report.
Now I want to automate the process by which once I select the report, the program selects the branch from the Branch table and the data relating to that branch and sends it. The report is based on a query where the branch name and the period range for the report are selected.
Can somebody help me with the VBA code for this ?